Google Sheets Project Tracker

A project tracker in the tool your team already has. No Asana, no Monday, no onboarding three people onto a new app for a six-week project. Just a clean Google Sheet with a task list, automatic overdue flagging, a simplified Gantt timeline, and progress tracking, all driven by conditional formatting and formulas that do the work for you.

For small teams and solo operators who'd rather open a sheet than learn another tool.

🪺 Who it's for

• Small teams running projects that don't justify dedicated PM software
• Freelancers tracking client deliverables and deadlines
• Non-technical managers who trust a spreadsheet more than a web app
• Anyone whose "project plan" currently lives in a Slack thread

🌊 What it solves

Most project tools solve an enterprise problem with an enterprise solution, then charge per seat. For a five-person project or a solo freelance gig, they're overkill, and the setup tax (assigning roles, configuring workflows, training the team) often outlives the project. A spreadsheet skips all of that. This one adds the structure you actually need without crossing into feature bloat: priorities, deadlines, status, progress, and a timeline view that fits on one screen.

⚙️ What's inside

• Task list with priority, assignee, due date, and status columns
• Conditional formatting that flags overdue tasks in red automatically
• Simplified Gantt-style timeline built with formulas (no add-ons required)
• Progress tracking with % complete and an overall project summary
• Live collaborative editing for team-wide visibility
• Works on anything that opens Google Sheets (laptop, tablet, phone)

🦆 A note from me

I built this because half the projects I've run didn't need Asana, they needed a shared sheet with a few smart formulas. This is that sheet, with the formulas already written.

Make a copy, add your first five tasks, share the link with your team.

This template includes a small cost to support my work. If the cost is a barrier, you can still get it for free on Gumroad. If you choose the free option, please consider leaving a review, sending a kind message, or providing any support you can. Your feedback truly means the world!