Project tracker

Who owes what, by when — a Status dropdown that keeps the progress score honest and a Rollup tab of cross-sheet COUNTIFs.

Use this templateSheets template
Project trackerWho owes what, by when — a Status dropdown that keeps the progress score honest and a Rollup tab of cross-sheet COUNTIFs.

Tasks

ABCDEF
1TaskOwnerStatusDueDoneNotes
2Draft the OpenAPI spec@priyaDone2026-06-18100%Reviewed with backend
3Review the data model@miaDone2026-06-20100%Two indexes added
4Build the sync endpoint@samDoing2026-06-2450%Behind a feature flag
5Write the e2e tests@leeTodo2026-06-270%Happy + error paths
6Ship v1 to beta@priyaTodo2026-07-010%Gated on the audit

Rollup

ABCD
1RollupValue
2Tasks5
3Done2
4Doing1
5Todo2
6Blocked0
7Complete50%
8
9
10
11
12
13
14
Task status
Total5Done: 2Doing: 1Todo: 2Blocked: 0
Task status data
LabelValue
Done2
Doing1
Todo2
Blocked0
Delivery timeline
Draft the OpenAPI spec — Done2026-06-18Review the data model — Done2026-06-20Build the sync endpoint — Doing2026-06-24Write the e2e tests — Todo2026-06-27Ship v1 to beta — Todo2026-07-01
Delivery timeline data
LabelStartStatus
Draft the OpenAPI spec2026-06-18Done
Review the data model2026-06-20Done
Build the sync endpoint2026-06-24Doing
Write the e2e tests2026-06-27Todo
Ship v1 to beta2026-07-01Todo