A Google Sheets project tracker is a spreadsheet with one row per task and columns for the task, its milestone, status, due date, owner and notes. Formulas turn those rows into percent complete, progress per milestone and a count of overdue tasks.
What’s in the template
| Column | What goes in it | Example |
|---|---|---|
Task | One piece of work that someone can finish | Homepage design |
Milestone | The phase it belongs to; keep names identical across rows | Design |
Status | One of four values: Not started, In progress, Blocked, Done | In progress |
Due date | A real date, written the same way on every row | 2026-11-18 |
Owner | The one person accountable | Priya |
Notes | Short context, links, what it’s waiting on | Second round of feedback due Monday |
How to set it up in Google Sheets
- Download the CSV above.
- Import it. In a new Google Sheet, choose File → Import → Upload, pick the file and choose Replace spreadsheet.
- Add a status dropdown. Select the Status column (C2 down), then Data → Data validation → Add rule, choose Dropdown and enter Not started, In progress, Blocked and Done.
- Color the statuses. With the same cells selected, choose Format → Conditional formatting: “Text is exactly” Done in green, Blocked in orange, In progress in purple.
- Freeze the header row with View → Freeze → 1 row, so the column names stay visible as the list grows.
Formulas for progress
Put these anywhere outside the task rows, for example in a small summary block to the right. They assume the template’s columns: A Task, B Milestone, C Status, D Due date.
| What it shows | Formula |
|---|---|
| Percent complete | =COUNTIF(C2:C,"Done")/COUNTA(A2:A) (format as a percentage) |
| Progress for one milestone | =COUNTIFS(B2:B,"Design",C2:C,"Done")/COUNTIF(B2:B,"Design") |
| Overdue tasks | =COUNTIFS(D2:D,"<"&TODAY(),C2:C,"<>Done") |
| Blocked tasks | =COUNTIF(C2:C,"Blocked") |
| Next due date | =MINIFS(D2:D,C2:C,"<>Done") (format as a date) |
Percent complete counts finished tasks only. That’s deliberate: it only moves when work is actually done, which keeps the number honest and stops debates about whether a task is “80% there”.
Tips that keep a tracker useful
- One row per task, one task per row. No merged cells, no blank spacer rows.
- Four statuses, no more. “Waiting”, “Review” and “Almost” all hide whether something is blocked or done.
- Identical milestone names. “Design” and “design phase” become two milestones as far as formulas are concerned.
- Real dates. “Next week” can’t be sorted or counted as overdue.
- Short notes. Link to documents rather than pasting them in.
Where a spreadsheet falls short
A tracker sheet is great for the team doing the work. It’s a poor way to show progress to anyone else: clients have to read a grid to work out where things stand, sharing it exposes owners and notes, and the “client copy” drifts from the real one. Before long there’s a file called Project_Tracker_FINAL_v7 (2) and nobody is sure which version is right.
Turn the sheet into a live journey with Waypoint
Keep working in the sheet, and give clients a live visual view of the same data:
- In Google Sheets, choose Share → General access → Anyone with the link (Viewer), and copy the link.
- In Waypoint, choose Google Sheets and paste the link. Waypoint finds your Task, Milestone, Status, Due date and Owner columns and shows a live preview.
- Name the destination, pick a world and share the journey’s link. Waypoint checks the sheet every 15 minutes, so the journey moves when you update a status.
Prefer not to share the sheet by link? Download it as CSV or Excel and upload the file instead.
Frequently asked questions
Does Google Sheets have a built-in project tracker template?
Google Sheets’ template gallery includes general project and timeline templates. This one is built for tracking progress by milestone and status, with formulas for percent complete, and it imports into Waypoint as is.
How do I calculate percent complete in Google Sheets?
Divide the number of finished tasks by the number of tasks: =COUNTIF(C2:C,"Done")/COUNTA(A2:A), where column C holds the status and column A the task name. Format the cell as a percentage.
How do I add a status dropdown in Google Sheets?
Select the status cells, choose Data → Data validation → Add rule, pick Dropdown and enter your statuses, for example Not started, In progress, Blocked and Done.
Can I share a Google Sheets project tracker with clients without showing notes or owners?
Not easily: anyone who can open the sheet sees every column. Waypoint can read the sheet and show clients only progress, milestones and the dates you choose; owners and notes are never shown on its live links.
Does the template work in Excel?
Yes. The template is a CSV file that opens in Excel, Numbers and Google Sheets. The formulas work the same way in Excel, and Waypoint also accepts Excel (.xlsx) uploads.