Metric for number of incomplete parent tasks on dashboard

Hi everyone,

I'm trying to figure out a way to add a metric to my dashboard that will count the number of incomplete parent tasks across all of my sheets.

I've gotten as far as creating a report that filters down to just the parent tasks that haven't been marked to "complete", but haven't been able to figure out a function to count the number of rows on this report.

I tried to create a metric sheet, using the COUNTIF() formula, but it would not let me reference the report. Anyone discovered any workarounds for this?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!