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…

Right you are @Dalmo_Mendonca ! Thank you!

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	2516	March 19, 2019
Sort() on list column rather than Filter() result?	3	611	April 3, 2019
Formula support for Sorting and Grouping tables	4	1708	January 31, 2022
Use a button to st	3	1280	March 19, 2021
Sort according to the result of a formula Product Feedback	0	427	November 20, 2019

Combine Sort() statements in one formula?

Related topics