Auto-Alphabetizing Drop Down Options
I'd like for the drop-down and filter options to auto-alphabetize after a user enters or edits the options. Currently, the options stay in the same order they were entered in, so I either need to alphabetize them in my head or outside of the platform for a more readable experience.
Answers
-
Great idea! That would be a great addition to Smartsheet features.
Please submit an Enhancement Request when you have a moment
As a possible workaround, you could maybe have a sheet/report where you add the values and then sort them.
Also, a solution that would be perfect for this use-case is the premium add-on, Data Uploader.
Is that an option?
More info:
Would that work/help?
I hope that helps!
Be safe and have a fantastic day!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I think you're correct. I don't know of a way to automatically alphabetize a drop down or filter option.
However, one alternative, if it's something that would make a big difference, is Data Uploader. You could create a sheet with all of your lists and sort them alphabetically, then use Data Uploader to update your drop down with that list at a regular time/date.
-
Thanks! These are definitely options I've considered, but it's such a simple usability enhancement that could be addressed on the back end. Depending on what we're using/creating in the sheet, manually alphabetizing can take up it's own chunk of time that's better spent doing actual work.
-
Happy to help!
Yes, I hope we'll see enhancements at this years Engage conference.
✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
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
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!