Dashboard is not showing correct past due counts

Rahul Bhandari · 10/15/21

Hello Team,

I have a metrics sheet to caluculate project status counts and then that count is linked to dashboard. for ex.to caluclate past due task count I use =COUNTIFS({% Complete}, <1, {Finish Date}, <TODAY(), {Parent Row}, =0, {Project Plan - DEMO Range 1}, <>1) in this {Project Plan - DEMO Range 1} is nothing but filtering out strike thorugh tasks. so whenevr there is a change in past due tasks in Project plan, dashboard does not show reflect acurate count. I have to manually need to go to metrcis sheet, refresh it and then it shows on dashboard. since I have many projetcs/metrcis sheets/dashboards this is impossoble to manually refresh everytime to get correct count on dashboard. any alternative or fix for this. thanks for your help.

Past Due count after refersh on dashboard.PNG

Report Counts - 8 past due.PNG

Today () Formula - Auto Refresh Issue.PNG

Andrée Starå · 10/15/21

Hi @Rahul Bhandari

I hope you're well and safe!

Please have a look at my post below with a method I developed to update the sheet(s) daily.

More info:

https://community.smartsheet.com/discussion/74527/daily-update-solution-without-the-need-to-open-the-sheet-use-zapier-or-similar

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Rahul Bhandari · 10/21/21

@Andrée Starå Thank you so much for this solution. just one query, having today helper column with record date automation is sufficient for sheet auto-refrsh or do I need to replace "Today()" in formula with "Today helper date".

Screenshot for your refrence.

Today Helper Automation.PNG

Today Helper column solution.PNG