Sheet Structured drop down list
Options
I am looking for a solution to create a drop-down list with 125 options, which can be structured using categories to help users navigate and find the right option. Ideally, I would like to implement a filter at the top of the drop-down list, similar to the filtering options in Excel, where users can click on a category to reduce the list and see only the corresponding options.
This will make it easier for users to find the option they need without having to scroll through the entire list. Do you have any suggestions on how to achieve this in a sheet?
Tags:
Comments
-
Hi,
I hope you're well and safe!
What I usually do in my client solution is one of the following.< < CATEGORY 1 > >
Item 1
Item 2
< < CATEGORY 2 > >
Item 1
Item 2
Or
< < CATEGORY 1 > >
Cat 1 - Item 1
Cat 1 - Item 2
< < CATEGORY 2 > >
Cat 2 - Item 1
Cat 2 - Item 2
Sometimes, I use Emojis to separate them even more clearly.
If it makes sense in a form or the sheet, I sometimes use multiple columns and then have the selected values in a main field.
Make sense?
Would any of those options work/help?
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!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.
-
Previously, I encountered a scenario where I needed to populate a large set of options in a dropdown, but only a few options were relevant for each row.
I found a great solution that suited my needs well. It involved listing all the options in a separate sheet and then using INDEX/COLLECT to display the options relevant to each row. Additionally, I implemented a dropdown column with 1, 2, 3 to select the appropriate option. While this approach may not be suitable for every use case, it has proven to be very effective for my specific requirements. More details about this solution can be found in this post.
