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

(Fer Calvano) #1

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!

(Suvrutt Gurjar) #2

i @Fer_Calvano, if you are

getting values from another table’s column , you may wish to try the expression

SORT(LOOKUPTABLE[LOOKUPCOLUMN])

(Suvrutt Gurjar) #3

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) #4

Hi, I’ve tried SORT(LOOKUPTABLE[LOOKUPCOLUMN]) and worked fine,

Thanks a lot!

(Suvrutt Gurjar) #5

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