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".

Best Answer