Hello,
I have a column set as ENUM with a drop down. “Allow other values” and “Auto Complete other values” are enabled. My goal is to make the drop down list sorted ascending. To accomplish this I added SORT(TableName[ColumnName]) in Valid if. This results in the proper sorting of items in the drop down list however the SORT expression removes the ability for the user to ADD a new item name.
Any assistance is appreciated.
Michael
Solved! Go to Solution.
Move the sort formula from the valid if to suggested values:
Thanks, Johnathan. That did the trick.
Michael
Hello,
I try the same thing
I have a enumList column with data separated by ','
It works well, but when I want to sort items, I lost the enumList
I put SORT(Table_name[enumList_Colum]) in Suggested values
Any idea?
Thanks and regards,
Alexandre
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |