It’s possible to combine Sort() statements using the Table UI, and to rearrange them to change sort priority. (see embedded View example) Is it also possible to combine Sort() statements using only a formula? Chaining Sort() performs a total re-sort with each new chain. (see embedded Canvas formula…

Hi Ander, When chaining sorts in formulas, each following sort has precedence over the previous. So the formula you’re looking for is [Sort Formula Combo Test].Sort(true,[Column 3]).Sort(true,[Column 2]).BulletedList() This is the opposite of using table sort, where the top criteria have precede…

Combine Sort() statements in one formula?

Filmos September 12, 2019, 7:32am 4

In case anyone else finds this topic and is looking for a more optimized (and more complicated) solution, I recommend reading this post.

Topic		Replies	Views
Sort order in a Lookup	5	2444	March 19, 2019
Sort() on list column rather than Filter() result?	3	569	April 3, 2019
How to combine If() formulas?	9	186	June 1, 2024
Combining data and sorting	6	201	March 28, 2024
Create a Table Sort Canvas Control Tips and Hacks	4	2408	April 28, 2020

Combine Sort() statements in one formula?

Related topics