Hi I have a dropdown list which I would like to sort to have the value 'All' at the top of the list and then each other value within the list to be in ascending order.
Currently i have a formula such as this for the dropdown list SortByColumns(colcomms,"Result",["All"]) however when i incorporate ascending into this it doesn't seem to work?
Solved! Go to Solution.
If by search box you mean a Text Input...then no. It does not deal with records. The formula provided produces a table of records.
What are you referring to in regard to search box?
@RandyHayes
I am referring to utilising a combo box to produce the same outcome but having the functionality to search for items aswell. Which i presume the formula will still work.
If you are referring to searching in the combobox...then yes, that will all work just fine.
If it is something else, please expand on your design a little so I can follow.
User | Count |
---|---|
248 | |
106 | |
82 | |
51 | |
43 |