Custom Sort Order - Sort by High, Medium, Low

#1

This should be inbuilt into the product at some point but for now here is a hack to get your table to sort in the way you want it ( High, Medium, Low)

Basically you create another table with the priority list and ranking.
Make your priority (in task table) a lookup to it.
Add a column that projects the ordering and then sort by that column. You can hide the column to keep it looking clean

4 Likes
#2

@mallika Another hack I’ve seen in Excel (not as clean) is just putting a number in front of the priority level so you can do a quick sort on the column:

18%20AM

1 Like
#3

Yes, that way a good one too. Just not clean and easy to manipulate but it works.