When stakeholders ask ‘where are we?’ the best answer is a chart they can read in 10 seconds. This Milestone Tracker gives you that chart — updated in real time, shared in one click, no software licence required.

What’s inside this Milestone Tracker template

• Colour-coded status — not started, in progress, on hold, and complete shown visually per task
• Baseline comparison — original planned dates shown alongside current dates to track schedule slip
• Summary row — automatic calculation of overall project completion percentage
• Export for client sharing — a clean version with internal notes hidden, ready to share in one click

How to use this Milestone Tracker template

1. Get access to the Gantt template and save a copy to your Drive.
2. List all project tasks in the task column, grouped by phase or workstream.
3. Enter start and end dates for each task — the Gantt bars generate automatically.
4. Assign an owner to each task and mark any dependencies in the notes column.
5. Update progress percentages weekly — the chart reflects changes immediately.

Why Google Sheets for Milestone Tracker?

The best project timeline is the one the whole team trusts. A Google Sheets Gantt chart updated by the people actually doing the work — rather than a PM re-entering data from emails — stays more accurate than any dedicated tool.

Frequently asked questions

Does the chart update automatically when I change dates?

Yes. Edit the start or end date of any task and the Gantt bar repositions immediately. No manual chart adjustments required.

Can I show dependencies between tasks?

The template includes a dependency notes column. For visual dependency lines, use the conditional formatting guide in the instructions tab to add connecting markers between linked tasks.

How do I use this for multiple projects?

Duplicate the project tab for each new project. Add a portfolio summary tab that shows the status and completion percentage of all active projects in a single overview.