Populating a dropdown based of the entry in another dropdown

Apologies if this has been asked and I just cant find it. I'm new to Smartsheet after spending several years working with Access.

I would like to have a dropdown auto-populate based off of the selection in another dropdown.

Each selection in the department dropdown will have multiple "areas" within them. So if I selected "Mill General" in Department, the Area dropdown should auto-populate with "Front Gate", "Fueling Station", "Oil Hall", etc. The purpose of the "area" dropdown would be to further narrow the criteria of the entry so that a search function later on may yield more specific results. See below:



Best Answer

Answers

  • MCorbin
    MCorbin Overachievers Alumni

    There isn't a way to automatically narrow down a dropdown list (I wish there was!)

    As an alternative, you can look at what Smartsheet did in the Engage'20 portal template that they made available for attendees. They created sections within the dropdown so you can tell which selections go with which categories (in this case, which sessions go with each time slot)


  • Thanks David,

    That is more work that I thought it would be but it sounds like it would resolve the problem. I have not played with logic much. I will try this out.

  • David Tutwiler
    David Tutwiler Overachievers Alumni

    It is a little clunky, for sure. But Logic is pretty powerful when looking at doing this kind of stuff.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!