Formula: calculate percentage based on certain criteria

Hi, please can you assist?

I have 2 worksheets, called "Position Requisition" and "Dashboard Data".

In the "Position Requisition" I have two columns, called "Total Train ATTR" and "Location"

In the "Dashboard Data" I have two columns, called "Primary Column" and "Totals"

I want to add up all the totals in the "Total Train ATTR" column that are associated with a location in the "Location" column and I want that total displayed as a percentage in my "Dashboard Data" sheet.

So if I have 6 Asheville's in "Locations" that totals up to 0.69 in "Total Train ATTR", then I want that to display 11.5% in my "Dashboard Data" sheet.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!