I'm trying to figure out a formula-free way to show summarized info. π
I have 3 Cities on my Sheet; each city has 'co-parent' rows, and under these co-parent rows are Tasks that have a Status. I'd like to have a Metric widget on my dashboard that shows the number of Tasks per Status, per City - for example, 'Tulsa' In Progress - 3, Blocked - 1, Complete - 2; 'Phoenix' Not Started - 1, At Risk - 2. I'm seeing it doesn't seem possible without a Sheet Summary, but I really have no idea how the formulas would work on that! I've made a regular Row Report and hope to be able to use that. If this doesn't make sense, please LMK and I can hopefully clarify more!