Project management

Project Tracker

You coordinate a product launch with 40 tasks across five people. The status meeting is on 15 April 2026 (cell L1). The team lead wants to know how long each task takes in working days, what is overdue, where the team stands overall, and a clean way to update statuses.

Deliverable: Working-day durations, days left, an overdue flag, a status summary, a status dropdown, highlighted overdue tasks, one person’s filtered view and a pie chart.

1. 1Working days10 pts
2. 2Days left10 pts
3. 3Overdue flag15 pts
4. 4Status summary15 pts
5. 5Status dropdown10 pts
6. 6Make overdue tasks stand out10 pts
7. 7Lena’s view10 pts
8. 8Where we stand10 pts