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

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.


  • Greg Gates
    Greg 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 Hook
    Jim 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 Williams
    J. 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.



  • 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.