Help

Sorting Formula Output

Topic Labels: Formulas
924 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Nicole_Merwin
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a formula that brings in data from multiple fields, such as the attached. There are around 40 of these formulas, I would like to be able to sort the output by the date shown (highlighted portion of the formula). Is this possible without using a factorial approach as that is not scalable in reality.
Looking for more of a ‘sort’ wrapping of the formula if at all possible.
Capture

1 Reply 1
Nathaniel_Grano
8 - Airtable Astronomer
8 - Airtable Astronomer

I don’t think there’s a direct way to do what you are asking (essentially you would like to specify a custom sort order for the unique data type that results from your formula). But here’s a hopefully-useful workaround!

  • Create another column that uses a similar formula, but the output of this formula is ONLY the date portion of the formula
  • Sort by this new column
  • If you like, you can also hide the sort column