Reference Sheet Summary fields in formula in sheet

Jake Gustafson

Thanks @Andrée Starå. I am well and safe. Hope the same for you.

I was not aware that the Grouping/Summarizing support of Reports was released for Dashboards. I have updated a few things to clean up the look of that data. Great, but would still like to be able to sort by Count of my Group (descending) to show the high volume areas for my grouped fields. Additionally, an option to Pareto that data out to show the top items making up the whole population to focus attention on.

The piece that I'm missing is an automated alert if my common numbers don't match. I was able to create a new Report that references the Sheet Summary values. But now I wish I could create an automation from this for any mismatches.