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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives