Sort order in a Lookup

[Jean_Pierre_Traets]

Hi @David_Clegg,

This post could be of your interest:

Combine Sort() statements in one formula?

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 example) This behavior makes sense, but then how to combine Sort() statements in a formula? USE CASE: Organize lengthy list of options in a “Select list”. NOTE: My eyes are loving the recently add…

Kind regards,
//JP