Skip to content
  • Try for free

    • Smartsheet Product Feedback & Ideas

    Smartsheet Product Feedback & Ideas

    Help shape the future of Smartsheet! Share your feature wishlist and improvement requests here.

    Sign in to submit new ideas and vote
    Get Started

    Sheet Structured drop down list

    ✭✭
    in Smartsheet Product Feedback & Ideas

    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:
    Share on FacebookShare on Twitter
    5
    Up
    5 votes

    Idea Submitted · Last Updated

    Comments

    • Community Champion

      Sheet Structured drop down list

      Jderoletz

      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.

      · Share on FacebookShare on Twitter
    • Community Champion

      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.

      https://community.smartsheet.com/discussion/111630/is-it-possible-to-have-a-drop-down-list-based-upon-criteria-from-another-column
      · Share on FacebookShare on Twitter

    Sign in
    Try for free

    Quick Links

    Categories

    Trending Ideas