My column in google sheet is enum. It had only 1 (one) data at initial.
After a time input data, there are many datas in this field.
Kindly help me know:
- How could I sort these data?
- Where new data (CH05, CH10, ABC…) were wrote in my app?
Regards,
Regards,
If you are allowing other values, rather than using the preset approach I might suggest using the ‘Suggested Values’ instead. If you do this your suggested values might be:
SORT(ThisTableName[ThisColumnName], true) to sort ascending
2 Likes
Thank you for your support.
After change fomular, the “Add or search” bar was disappeared.
I also want to keep it for additional data without existing list.
Please kindly requested instruct me how could I do?
Regards,
Can you provide a screen shot of the entire column set up including the ‘Auto compute’ section? It might take 2 screen shots to capture all of it.
1 Like
Scroll down further in the same window from the first screen shot and provide what is at the bottom.
1 Like
Remove the expression in Valid If and have the same expression in ‘Suggested Values’ under Auto compute section instead. Then also remove everything from ‘Values’. I think that should do it.
2 Likes
Can you provide the screen shots again after you made the changes? Please include ‘Suggested Values’ under Auto Compute in one of the screen shots.
1 Like
Can you try similar expression, using ORDERBY instead of SORT ?
In the “suggested value” field
Such as
ORDERBY( tableName[key_column], [sortColumn], FALSE )
In this specific case ORDERBY would not work. Typically Orderby would take the IDs, so it would treat it as a reference which is not the case.
2 Likes
