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!
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
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
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |