SpreadsheetFormulas

Project Task Tracker

Tasks with owners, priorities, due dates, and a self-updating overdue flag — plus percent-complete and overdue counts for standups.

Made for: Team leads and project coordinators who need a tracker that maintains itself.

Download for Excel (.xlsx)

Free, no sign-up. For Google Sheets: upload via File → Import — all formulas carry over.

What's inside (sample rows)
1TaskOwnerDue DateStatusFlag
2Send contractAna Torres2026-06-28In ProgressOverdue
3Book venueBen Okafor2026-07-15In ProgressOn Track
4File permitsCara Lim2026-07-01CompleteOn Track

Formulas built in

=IF(AND(D2<TODAY(),E2<>"Complete"),"Overdue","On Track")
Overdue flag per task
=COUNTIF(E2:E6,"Complete")/COUNTA(E2:E6)
Percent complete