Overdue Tasks Metric
I have an individual task report set up for everyone in the company which aggregate tasks from our project sheets. Then, we have an overdue task report that displays all overdue tasks for everyone, grouped by the assigned-to column. We have a summary field on the overdue report counting everyone's current tally of overdue tasks, and also the total sum across the company. We want to print that metric on our portfolio dashboard and track what the overdue count is. I am so confused by why smartsheets offers reports with summary values but doesn't allow you to display them on a dashboard. I'm sure theres a million ways do work around this. How can I get this this value on a dashboard without doing a clunky report widget?