Sort by Priority - High, Medium and Low

Gaurav Chauhan
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,