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 added formula parentheses context shading !