Dropdown list column sorting
I'm working with a sheet that has an unrestricted dropdown list column that the sheet is sorted by. I've found that the column is sorted alphabetically first by the values that are in the dropdown list and then it starts over alphabetically with the values that are not added into the dropdown list. We don't want to add all values to the dropdown, just the most common ones. That is why we have left it unrestricted. Is this as expected? Is there any other way to get a comprehensive alphabetical sort without added all values to the dropdown list?
Best Answer
-
Here is a way to get an alphabetical sort without adding all the values to the drop-down list.
- Create another column and make its value the value in the drop-down list with the column formula.
- Sort by that other column.
Answers
-
Here is a way to get an alphabetical sort without adding all the values to the drop-down list.
- Create another column and make its value the value in the drop-down list with the column formula.
- Sort by that other column.
-
@jmyzk_cloudsmart_jp Thank you!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives