Skip to main content

Hi, IS it possible to sort this list of times, earliest to latest? I can only sort A-Z and this is what it returns:


These seem like consistent values. Can you convert it to a Single Select field? Single Selects let you define what the sort order for the options are, which your Views can adopt.

Worked a treat, many thanks.

unfortunately, this isn’t an option. As the data is brought in automatically, it needs a single line text field for it to sync properly. What other solutions are there?


Thanks

unfortunately, this isn’t an option. As the data is brought in automatically, it needs a single line text field for it to sync properly. What other solutions are there?


Thanks


Then create a single select field, and use an Automation to copy the Text field’s value into it. Sort by the select field.

unfortunately, this isn’t an option. As the data is brought in automatically, it needs a single line text field for it to sync properly. What other solutions are there?


Thanks



Use a SWITCH() formula field to convert the strings into a sortable number.


SWITCH( {Due Time},

  "7:00 AM - 9:00 AM", 7,

  "11:00 AM - 1:00 PM", 11,

  "3:00 PM - 5:00 PM", 15

)

Reply


Terms & Conditions