Sort Order - Days of Week

[Steve_Long]

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

[Btbml]

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]

The formula doesn’t work…

[Tim_Sullivan]

@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})