I need a simple way to group and summarize data at two levels.

MJ215 ✭✭
edited 06/11/21 in Formulas and Functions

I have Risk Area- BU- Risk Factor and multiple levels of each. And I want to show the average risk rating and average controls rating for each Risk Area, and Business Unit.

Is there a quick formula that would show the average for each risk and bu?

What would be the best way to approach this? I would like to have the average risk appear on the master table as I use that to connect to Tableau for some nice visualization.

I just want to show the average at each level.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!