Sheet Summary

How do I reference a column in sheet summary that is on the current sheet? I looked at the article on Sheet Summary and it says to use [Field Name]# but that is not working. I am trying to reference the Area column on this sheet.


I need to calculate an average percentage of each area's submissions. Ultimately I want something like this:


That I can translate into something like this:


and use to make a chart on a dashboard. Any ideas?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!