Help

Re: Sort Order - Days of Week

561 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Steve_Long
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a single select field “Day of Week” with Mon, Tues, Wed, etc, etc.
I would like to be able to sort my table in that order - but it seems like we only have the option to sort alphabetically (which results in an incorrect order). Once this table is ordered properly, I’m assuming that order will refer over to the linked field in my other tables - is this correct?
Is this sorting possible?
Thanks for the help

3 Replies 3
Btbml
7 - App Architect
7 - App Architect

Create a formula field and sort by that (you can hide it after you’re done)
SWITCH({Day of Week},“Mon”,1,“Tues”,2,“Wed”,3,“Thurs”,4,“Fri”,5,“Sat”,6,“Sun”,7)

Drew_Allred
4 - Data Explorer
4 - Data Explorer

The formula doesn’t work…

@Drew_Allred

Try the formula below. It will give you the day number of the week. Sunday = zero, Mon = 1, Tues = 2, etc.

weekday({date})