Sort Grouped Report by Summary Values?

System

This discussion was created from comments split from: Will there be a way to sort Grouped Reports based on the count of the grouping?.

TaH

Was there are resolution to this? I attempted using the formula (SUMIF) in a hidden column and it did not pull all the data I needed to the report. In my case, I am sorting by dollar amount.

What I need is to group by one column, then sort the grouped columns ascending by the sums. The report will only let me sort by group name, not the sum of the groups.

Any recommendations?

Georgie

Hi @TaH,

There currently isn't a way to group by report summary. I found a similar idea post here: Sort Report by the Summary result. Please add your vote to this idea if it matches your request. You’ll then receive updates when the status of the idea changes! 

If the request provided doesn’t quite match your suggestion, please create a new Idea Post in the Smartsheet Product Feedback and Ideas topic. This will allow other users to vote on your enhancement idea!

Thanks,

Georgie