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.
