Dependent drop down list

This any way to have the dropdown lists only display certain options based on what is selected in another cell e.g. If you select January in the Month cell the drop down box only displays the week commencing dates in January?

Answers

  • That sounds like conditional formatting or even the logic questions we have in forms. Unfortunately, the dropdown menu cannot be customized using either of the mentioned methods.

  • Maxine Roberts
    Maxine Roberts ✭✭✭✭

    It not using forms it's inputting data straight into a grid, I have asked the question in the EAP group as I think this may be a function that would be beneficial to be included as it's not just myself within my organisation who has found Smartsheet a bit lacking in this area.

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @Maxine Roberts

    To add to Valdeir's excellent advice/answer,

    As a possible workaround, you could use a combination of Conditional formatting, formulas showing descriptive text, and multiple helper columns for each drop-down option.

    Make sense?

    Would that work/help?

    I hope that helps!

    Be safe and have a fantastic week!

    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.

  • Maxine Roberts
    Maxine Roberts ✭✭✭✭

    @Andrée Starå not really it would ideally need to display only the options in the drop down that are applicable either from another piece of information in the grid or depending on the data in another grid.


    I just think the functionality needed for this is not available at present which is why I raised it in the EAP group as this may be of benefit to be added.

  • @Maxine Roberts, I completely agree with your assertion that this would be useful. I need to create a form that has multiple layers of cascading selections that can only be realized by using dependent dropdowns. I have used this many times in MS Excel and it is disappointing that this functionality is not available in Smartsheet.

  • Jon SF
    Jon SF ✭✭
    edited 03/26/21

    Agree. Instead of having 5 different sheets for slightly different lists (e.g. RAID versus Action Items), I have everything together. So I'd like the status field to show only options for the "type" of information entered in that row (e.g. risk type has the status options of "mitigated" or "accepted" and action item type should have "complete" "in progress" ETC.

  • Sherry Fox
    Sherry Fox ✭✭✭✭✭✭
    edited 08/05/22

    I agree, this IS a needed feature, and I use this constantly within Excel. It is not any form of conditional formatting. If in Dropdown 1 there are 10 different choices to be made, dropdown 2 would have different choices for EACH of those chosen in the first dropdown. As an analyst, this is quite helpful, as the end user often does not know the the proper choices. So they make the first choice, and we give them a small # of choices that are relevant ONLY to that first choice. It improves the accuracy of the data received substantially.

    Sherry Fox

    Business Process Analyst 3 | C5ISR Group

    HII | Mission Technologies

    EAP | Mobilizer | Automagician | Superstar | Community Champion

    https://www.linkedin.com/in/sherryfox/

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!