Sorting Formula Output

Nicole_Merwin · ‎Sep 24, 2022

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.

Nathaniel_Grano · ‎Oct 03, 2022

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