Flori / Templates

Project tracker template for Excel and Google Sheets

By the Flori team · Published · Updated

A project tracker is a spreadsheet with one row per piece of live work, showing who owns it, its status, its due date and how far along it is, so you can see what is late or stuck at a glance. This page gives two layouts: a task tracker for one project and a multi-project tracker for five to ten client projects. Download the task tracker CSV, the multi-project tracker CSV or the formulas and setup steps. Both CSVs open in Google Sheets and Excel.

A tracker follows work already under way. To build the schedule first, use the project plan template; for cards in columns, see the kanban board examples.

Layout 1: a single-project task tracker

One row per task. Use these ten columns, in this order, so the formulas below work as written.

ColumnWhat goes in itRule
A TaskA verb and an objectOne person can finish it within a week
B OwnerOne nameNever "team"
C StatusDropdown: Not started, In progress, Blocked, DoneNo other values
D PriorityDropdown: High, Medium, LowSet once
E StartDatePlanned start
F DueDateEvery task gets one
G % completeA whole number from 0 to 100100 only when Status is Done
H Days lateFormulaNever typed
I BlockerWhat it waits for, and from whomFilled only when Status is Blocked
J NotesShort context, and "Done 13 Nov" when a task closesOne line

Cell M2 holds the as-of date: =TODAY() for daily use, or a fixed date to check the sample.

Filled sample: holiday menu and online ordering

Saltbox Catering is a fictional eight-person caterer launching a holiday menu with online ordering, from Monday 2 November to Wednesday 2 December 2026. Status is as of Wednesday 18 November 2026; the CSV writes dates as 2026-11-02.

TaskOwnerStatusPriorityStartDue%Days lateBlockerNotes
Agree holiday menu and pricesMayaDoneHigh2 Nov6 Nov1000Done 6 Nov
Cost each dish and set the minimum orderTomDoneHigh4 Nov10 Nov1000Done 10 Nov
Choose the online ordering serviceTomDoneHigh5 Nov12 Nov1000Done 11 Nov
Photograph 12 menu dishesPriyaDoneMedium9 Nov13 Nov1000Done 13 Nov
Print order labelsLeoDoneLow12 Nov13 Nov1000Done 12 Nov
Hire two seasonal driversMayaBlockedMedium2 Nov13 Nov305Checks pending
Confirm turkey and ham quantities with supplierMayaBlockedHigh9 Nov16 Nov252No price listAsked 11 Nov
Write menu descriptionsPriyaIn progressMedium11 Nov17 Nov601
Update opening hours on the websiteLeoIn progressLow16 Nov18 Nov500
Order holiday packagingLeoNot startedMedium16 Nov19 Nov00
Set up ordering page and card paymentsTomIn progressHigh13 Nov20 Nov500
Test five orders end to endPriyaNot startedHigh23 Nov25 Nov00
Train staff on order pickupMayaNot startedMedium25 Nov27 Nov00
Email past customers about the menuPriyaNot startedMedium30 Nov1 Dec00
Go live and announceMayaNot startedHigh2 Dec2 Dec00

Formulas for the task tracker

Tasks sit in rows 2 to 16; ranges run to row 200 so new rows count. Every function here works the same in Google Sheets and Excel 2016 or later.

What it showsPut it inFormulaSample result
Days lateH2, then fill down=IF(OR(F2="",C2="Done"),0,MAX(0,DAYS($M$2,F2)))5, 2 and 1 on the three late rows
Project % completeM4, formatted as a percent=AVERAGE(G2:G200)/10048% (715 / 15 = 47.7)
Share of tasks doneM5=COUNTIF(C2:C200,"Done")/COUNTA(A2:A200)33% (5 of 15)
Overdue tasksM6=COUNTIF(H2:H200,">0")3
Due this week, not doneM7=COUNTIFS(F2:F200,">="&($M$2-WEEKDAY($M$2,3)),F2:F200,"<="&($M$2-WEEKDAY($M$2,3)+6),C2:C200,"<>Done")5
Count by statusM8 to M11, labels in L8 to L11=COUNTIF($C$2:$C$200,L8), filled downNot started 5, In progress 3, Blocked 2, Done 5

How the references work:

Highlight overdue and blocked rows

Make two rules on A2:J200: =$H2>0 for overdue (red) and =$C2="Blocked" (amber). The $ before the column letter colours the whole row.

Google Sheets:

  1. Select A2:J200.
  2. Click Format, then Conditional formatting.
  3. Under "Format cells if", choose Custom formula is.
  4. Type =$H2>0, pick a fill colour, and click Done.
  5. Click Add another rule and repeat with =$C2="Blocked".

Excel:

  1. Select A2:J200.
  2. On the Home tab, click Conditional Formatting, then Manage Rules, then New Rule.
  3. Choose "Use a formula to determine which cells to format".
  4. Type =$H2>0 in "Format values where this formula is true".
  5. Click Format, choose a fill, and click OK twice. Repeat with =$C2="Blocked".

For the Status dropdown, select C2:C200. Google Sheets: Data, Data validation, Add rule, Dropdown, then type the four values. Excel: Data, Data Validation, Allow: List, Source: Not started,In progress,Blocked,Done.

Layout 2: a multi-project tracker for five to ten client projects

One row per project; each project's tasks stay in their own task tracker tab, and the guide to managing multiple clients covers capacity around a sheet like this. Columns: A Project, B Client, C Owner, D Stage (dropdown: Kickoff, In delivery, Client review, Launch), E Start, F Due, G % complete (from the project's task tracker), H Health (formula), I Next milestone (the next thing the client will see), J Milestone date and K Last update (the date the owner last checked the project). The as-of date sits in N2.

What it showsPut it inFormula
HealthH2, then fill down=IF(OR(AND($N$2>F2, G2<100), AND(J2<>"", $N$2>J2)), "Late", IF(OR(G2<100*DAYS($N$2,E2)/DAYS(F2,E2)-15, DAYS($N$2,K2)>7), "At risk", "On track"))

The rule it applies, checked in this order:

  1. Late: the due date has passed and the project is under 100%, or the next milestone's date has passed.
  2. At risk: percent complete is more than 15 points behind the share of time used, or nobody has updated the row for more than 7 days.
  3. On track: everything else.

Filled sample: a four-person studio

Northline is a fictional marketing studio with seven live projects, as of Wednesday 18 November 2026. On the sheet, start, due, milestone and date are separate columns.

ProjectClientOwnerStageStart to due%HealthNext milestone, dateLast update
Website refreshFernwood DentalAnaIn delivery5 Oct to 11 Dec55On trackHomepage design approved, 20 Nov17 Nov
November SEO retainerHarbor PhysioBenIn delivery2 Nov to 30 Nov50At riskNovember report sent, 30 Nov9 Nov
Brand guidelinesCobalt CoffeeAnaClient review12 Oct to 13 Nov90LateClient sign-off, 13 Nov16 Nov
Newsletter setupJuniper YogaCaraKickoff16 Nov to 18 Dec5On trackKickoff call held, 19 Nov16 Nov
Winter sale campaignAtlas BikesBenIn delivery26 Oct to 4 Dec30At riskAd creative approved, 24 Nov18 Nov
Trade show graphicsPine and Pike FurnitureCaraLaunch19 Oct to 27 Nov80On trackPrint files sent, 20 Nov17 Nov
Annual report designLakeside Food BankDevIn delivery9 Nov to 15 Jan 202720On trackFirst layout draft, 27 Nov13 Nov

Check your copy against these: 4 on track, 2 at risk, 1 late, average 47% (330 / 7). Harbor Physio is at risk because its last update is 9 days old; Atlas Bikes because 59% of its time has gone (23 of 39 days) at 30% done. Cobalt Coffee is late: its due date, 13 November, has passed. In N4 to N6, =COUNTIF($H$2:$H$50,M4) filled down counts each health value against the labels in M4 to M6.

A weekly routine that keeps the tracker true

WhenWhoWhatTime
Friday by 4pmEach task ownerUpdate status, % and blocker on their own rows only5 minutes
Monday 9:00Project leadSort by days late; send one message per blocker naming who owes what15 minutes
Monday 9:15Business ownerCall the owner of every At risk or Late project; write the date in Last update10 minutes per 5 projects

A status report from the tracker in five minutes

Each section of the project status report template is a filter on the task tracker:

  1. Finished this period: Done rows whose note date falls in the period.
  2. In progress: In progress rows, with owner and due date.
  3. Risks and blockers: Blocked rows, copying the Blocker column word for word.
  4. Coming next: rows due this week and next.
  5. Overall status: green, amber or red, with the overdue and blocked counts as evidence.

Saltbox's first line: "Amber: 3 tasks overdue and 2 blocked (supplier price list, driver background checks); go-live on Wednesday 2 December holds if the price list arrives by Friday 20 November."

When a spreadsheet tracker stops working

A spreadsheet never reminds anyone; a red row only helps whoever opens the file. Emailed copies drift apart. And it is only true if people update it.

The test: run the Monday routine for two weeks. Move to a tool if either week shows a row with no update for over 7 days, a task living in email or chat but not the sheet, or more than about three people editing.

Add a RACI chart when nobody is sure who approves, and a project budget template to track hours or money. For customers rather than projects, use the Google Sheets CRM template.

The same tracker in Flori

Flori is a CRM with project management for 1 to 20 person businesses. Each project holds tasks with an owner, a status (To do, In progress, Waiting, Done), a priority, a planned date, a due date and a blocker reason. My work lists each person's tasks across projects, and dashboards show tasks by status, by assignee and due this week. Every task is marked On track, At risk or Off track from its due date, and on every plan a project can set work-in-progress limits that warn rather than block. The same tasks can be shown as a Gantt chart with dependency lines and milestones, where dragging a bar previews the knock-on dates before you confirm. Flori does not import a plain spreadsheet as tasks: task import reads exports or connections from Asana, Trello, monday.com, Airtable, Notion, ClickUp, Linear, Jira and GitHub. The free plan holds 3 active projects, so a seven-project tracker needs Core ($12 per person a month, or $10 billed yearly).

FAQ

What should a project tracker include? Task, owner, status from a fixed list, priority, start, due, percent complete, days late, blocker and notes. A multi-project tracker adds client, stage, health, next milestone and last update.

Is there a free project tracker template for Excel? Yes. Download the task tracker CSV above, open it in Excel, then paste the formulas from the table into H2 and M4 to M11. Leave the as-of date at 18 November 2026 and compare your results with the figures on this page.

How do I make a project tracker in Google Sheets? Choose File, then Import, pick the task tracker CSV and choose Create new spreadsheet. Add the Status dropdown, the days late formula and the two conditional formatting rules. The formulas are the same as in Excel.

Why do my formulas return an error or zero? Usually the dates came in as text. Type =ISTEXT(F2) in a spare cell: TRUE means the date is text. Retype it, or convert it with =DATEVALUE(F2) in a helper column formatted as a date.

Start your workspace