DASHBOARD SHOWING NUMBER OF OVERDUE TASKS

TeeM

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.

Chris McKay

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

TeeM

Thanks Chris.