A project falls apart in small ways. A task with no owner, a due date nobody checked, a milestone that slipped a week while everyone was busy with the next thing. This spreadsheet keeps the whole project in one Google Sheets file, so the state of the work is always one look away.
What it is
A native Google Sheets template, not a printable and not an Excel workbook. It comes as a blank template plus a separate fictional sample, with a three-page PDF setup guide. You open the template link, choose Make a copy, and it saves to your own Google Drive. You need a Google account to save your own copies. It is built for Google Sheets in a desktop browser; a wider desktop screen helps with the task table.
There are four tabs: Overview, Tasks, Milestones and Start Here. Together they hold 100 task rows and 10 milestone rows, one project per copy. When you finish a project, make another blank copy for the next one.
Start with one row per task
Each task gets one row and one task ID, linked to a milestone ID. The row holds the task name, owner, start date, due date, priority, status, next action and notes. Owner, start date and notes are optional — but every incomplete task needs a next action, because that is what turns a list into a plan.
The built-in checks flag missing details, duplicate task IDs, unknown or unclear milestone links, invalid dates and a start date after its due date. Each row shows its first issue; fix it and check again until the row reads Ready. Keep the existing rows — the formula ranges do not extend beyond the 100 tasks and 10 milestones, and formula areas are protected, so preserve them when clearing sample inputs.
Check the Overview before you start the day
The Overview is where the project becomes a short to-do list. Enter the project name and review date, and it shows entered tasks, valid tasks, completed tasks, completion percentage, overdue work, blocked work and cancelled tasks, with a chart of task counts by status.
Valid open tasks show Overdue, Due today or Upcoming, based on the review date you entered. Done and Cancelled tasks show Closed. The review date does not advance on its own — update it each time you review, or the due flags will be wrong. This sheet sends no reminders and no notifications; the review is the habit.
Milestones show the shape of the project
Each milestone has a unique ID, a name and a target date. The linked summaries calculate, per milestone, how many tasks are valid, how many are done, the completion percentage and how much is overdue. That is how you see whether a milestone is genuinely on track or only looks that way because its tasks have no due dates.
Completion is the number of Done tasks divided by valid non-cancelled tasks. Cancelled tasks and records with unresolved input errors are excluded. Blocked is a status and overdue is a date flag — a task can be both, so those counts overlap. Milestone target dates do not override individual task due dates.
A simple weekly habit
Once a week, open the Overview, set the review date, and work through what it flags: overdue tasks, blocked work, and tasks with no next action. The fictional sample is there to show how a filled project looks before you start your own. Keep an untouched blank copy alongside it.
Setup, in six steps: download and extract the ZIP, read the PDF guide, sign into your Google account, open a template link, choose Make a copy, then enter your project name, review date and milestones before adding tasks.
What it does not do
This organizer does not send reminders, schedule notifications, contact anyone, or track time or budgets. It has no Gantt chart and no task dependencies. You do the project work yourself. It only keeps the record straight, so nothing slips because it was written on a scrap of paper.
Get the spreadsheet
Shop on Etsy Shop on Payhip Get it on Gumroad
Related reading on Teacher Planning Hub: the Job Application Tracker post — the same "one row, one ID, one next action" habit, applied to a job search — and the IEP Toolkit combo post, for keeping a caseload organized the same way.
0 Comments