A tracker is a single place where tasks, issues, and updates are organized.

Without it, you’ll keep asking:

1. 1. Where are we?
   2. Who is doing what
   3. What’s delayed?

With it, you can clearly see:

1. What was planned on Monday.
2. What has been updated by Friday.
3. Where problems or delays exist.

Google Sheets is free, simple, and allows real-time collaboration. That’s why we use it.

How to Do It

You’ll need three kinds of trackers in your Google Sheet:

1. Weekly Tracker → For tasks in progress this week.
2. Backlog → For tasks that will be done later.
3. Issue Log → For problems you discover during testing, meetings, WhatsApp chats, emails, or calls.

Each tracker lives on its own tab inside the same sheet.

Checklist for Building Your Tracker

1. Open a new Google Sheet and rename it: [Project Name] Tracker.
2. Add 3 tabs: Weekly Tracker, Backlog, Issue Log.
3. Add columns (Task, Responsibility, Start Date, Due Date, Status, Test Status, Priority, Notes).
4. Use dropdowns for Status (To Do, In Progress, Completed) and Test Status (Tested, Blocked, Kickback, Not Tested).
5. Fill in sample tasks/issues so you and your team can practice updating it.
6. Share the sheet with the team (Commenter or Editor access).

Examples

1. Weekly Tracker Example:
   1. Design Homepage – John – 01/15 – 01/20 – In Progress – Not Tested – High – Awaiting review.
2. Backlog Example:
   1. Refactor Payment API – Jane – Medium – Blocked until requirements are clear.
3. Issue Log Example:
   1. Login button unresponsive – Found during Exploratory Testing – 01/18 – Dev Team – Open.