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
Sort Order - Days of Week
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)
+10The formula doesn’t work…
Try the formula below. It will give you the day number of the week. Sunday = zero, Mon = 1, Tues = 2, etc.
weekday({date})
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.