Help

Sorting time earliest to latest

Topic Labels: Formulas
2030 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Harry_Batten
5 - Automation Enthusiast
5 - Automation Enthusiast

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:

Screenshot 2022-05-22 at 16.49.00

5 Replies 5

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.

Harry_Batten
5 - Automation Enthusiast
5 - Automation Enthusiast

Worked a treat, many thanks.

Harry_Batten
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

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
)