Metrics from multiple sheets
I'm trying to create a high level metric that sums the number of tasks in 10 different sheets. I tried to do a summary sheet, but that only summarizes the tasks in a report format. I want to roll those up into a total metric on a dashboard. Here's some snippets: (Sheet 1 and Sheet 2).
I tried doing a summary sheet, and from there did a metrics sheet.
End result: On the dashboard I'd want "Total Tasks completed, Total tasks in progress".