All templates
Projects
Project Tracker
Keep tasks, owners and deadlines visible in one sheet.
Tasks3 rows
| # | ATask | BOwner | CStart | DDue | EStatus | F% done | GDays left |
|---|---|---|---|---|---|---|---|
| 1 | Draft brief | Priya | 01 Oct | 04 Oct | Done | 100% | 0 |
| 2 | Design review | Marcus | 05 Oct | 11 Oct | In progress | 60% | 3 |
| 3 | Client sign-off | Priya | 12 Oct | 16 Oct | Not started | 0% | 8 |
What it tracks
- Tasks
- Owners
- Due dates
- Progress
Included sheets
TasksPeopleDashboard
Key calculations
- Days left
- =MAX(0,D2-TODAY())
- Overall progress
- =AVERAGE(F:F)