Sort by Priority - High, Medium and Low

Gaurav Chauhan

Hi Team

I have a Priority Column with dropdown High, Medium and Low.

Since these cannot be sorted based on actual priority on Smartsheet Report and hence on Dashboard view, I have added a IF helper column that matches High to 1, Medium to 2 and Low to 3.

Issue being, when I sort the SS Report by this helper column, project get aligned correctly in order.

But as soon as I 'Group' them using Priority, the helper column sort doesn't work.

Please suggest,

Paul Newcome

You would have to group by the helper column. Instead of just using numbers, you can use text strings that start with the numbers.

1. High
2. Medium
3. Low

Gaurav Chauhan

Thanks.. Yes that what I actually did after posting my question. thank you.

Paul Newcome

Happy to help. 👍️