DASHBOARD SHOWING NUMBER OF OVERDUE TASKS

Options
TeeM
TeeM ✭✭✭
edited 12/09/19 in Smartsheet Basics

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

  • Chris McKay
    Chris McKay ✭✭✭✭✭✭
    Options

    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
    TeeM ✭✭✭
    Options