How To Sort by Report Sum

Jonna Critchley

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?

Andrée Starå

Hi @Jonna Critchley

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Jonna Critchley

@Andrée Starå any thoughts for a work around in the interim?

Andrée Starå

@Jonna Critchley

The only workaround I can think of would be to recreate the same in a so-called master metric sheet that could be summed.

Would that work/help?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!