How To Sort by Report Sum

Options

Hi There!

I have a report: https://app.smartsheet.com/b/publish?EQBCT=892ee58c40f64b28b1128f4216f43dae 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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!