Hi, is there any way to always sort enum valu...

Fer_Calvano
Participant II

Hi, is there any way to always sort enum values (coming from another table through a Valid if condition) sorted A-Z? They currently appear in the order Iโ€™m loading them to the original table. Thanks!

0 4 955
4 REPLIES 4

i @Fer_Calvano, if you are

getting values from another tableโ€™s column , you may wish to try the expression

SORT(LOOKUPTABLE[LOOKUPCOLUMN])

You may find this sample app also useful

appsheet.com - Ordered Dropdown - How to order/sort the values in dropdowns

Hope this helps. Ordered Dropdown - How to order/sort the values in dropdowns appsheet.com

Fer_Calvano
Participant II

Hi, Iโ€™ve tried SORT(LOOKUPTABLE[LOOKUPCOLUMN]) and worked fine,

Thanks a lot!

If there are many columns that you are referring to from lookup table in your current table ,you may with to try

SORT(SELECT(LOOKUPTABLE[LOOKUPCOLUMN],TRUE))

I request you togo through following post that you may find useful for referring to many columns from another table

plus.google.com - Help with Dynamic Drop down Lets say i have a table list with three columnโ€ฆVโ€ฆ

Help with Dynamic Drop down Lets say i have a table list with three columnโ€ฆVโ€ฆ plus.google.com

Top Labels in this Space