Skip to main content

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

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)

The formula doesn’t work…

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


Reply


Terms & Conditions