Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Drop down list dependent on the data from other column

09/30/16 Edited 12/09/19

Hi. Is it possible to create a dorpdown list that is dependent on the option selected in other column. For example, when I select "Audit Department" in column A, the list of audit tasks will only appear in the dropdown list in column B and when I select "Tax Department" in column A, only the Tax related task will appear in column B dropdown list. 

 

It's going to be a long list if I will put all the tasks in one dropdown. Thanks in advance.

Comments

  • Greg GatesGreg Gates ✭✭✭✭✭

    Someone definitely correct me if I'm wrong, but I don't think it's possible to dynamically update the choices in a dropdown column. Sorry! Not a bad feature to request though.

  • Jim HookJim Hook ✭✭✭✭✭
    edited 09/30/16

    Not possible now but it sounds like a nice feature. One of Smartsheet's weaknesses is the inability to have global dropdown lists and features like the one you asked about. 

  • J. Craig WilliamsJ. Craig Williams Top Contributor

    Depending on your work-flow, there are 3rd party alternatives

     

    For example, if you have a website, Gravity Forms can have conditional drop-downs and with a small amount of API code can bring in the drop downs from Smartsheet.

     

    Again, depends on your workflow.

     

    Craig

  • Does not Smartsheet has dependant dropdown lists? 

    It is an absolutely critical feature. 

    I cant imagine any serious workflow with 100-200 different items which do not have dropdowns from another lists.

     

This discussion has been closed.