DASHBOARD SHOWING NUMBER OF OVERDUE TASKS
Hello All, I want a dashboard to show the number of overdue tasks for each team member. Currently each team member has their own report showing their respective tasks from various sheets. However, from a management point of view, we want to show the number of overdue tasks on a single dashboard hopefully populated from the report sheets.
Comments
-
Hi TeeM,
Can you not simply add report widgets for each of the existing reports? Or create a new report without the Who? criteria that currently specifies Current User?
If you're looking for a metric (i.e. a count of overdue tasks), then you can either pop a formula like =COUNTIF(Finish:Finish, <TODAY()) into your project plan sheet or create a new sheet that you can store project metrics and use cross-sheet references to count the overdue tasks (like the formula above).
Kind regards,
Chris McKay
-
Thanks Chris.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives