Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Define sort order at same time as creating a conditional columns

I am using a conditonal column to group durations (days) into custom groups "Range" eg less that 30 = less than 1 month else if less that 60 = 1 to 2 months else if less than 90 = 2 to 3 months otherwise = great than 3 months As my "Range" custom column is not text it does not sort in this order (instead alphabetically)- and cant sort the column by duration as that is not unique. So I know have to do another conditional column to specify sort order. Would be great if while constructing the first conditional column you could tick a flag to say - sort by this order. Or have an extra cell on each line so you could specify a sort order number as you go.
Status: New
Comments
fbcideas_migusr
New Member
Status changed to: New