How To Sort by Report Sum


Hi There!

I have a report: that I've built from about 40 sheets...Meeting Trackers. We track across all our workgroups who attends and how many meetings they attend.

This report by Attendee Name (Primary), sums the total number of meetings they've attended across all the workgroups (as they can attend more than one, many times several workgroups).

What I can't figure out is how to SORT this report by the Sum column.

For instance, Catherine Clark has attended 202 meetings. When I sort by Sum, it sorts the totals of each meeting she's attended, not the total number of all meetings together. What I'd like to do is have her show (or whoever it is that has the highest attendance) at the top of my report going down from there.

How would one accomplish this?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!