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!