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.
0
This discussion has been closed.
Comments
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.
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.
+1
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.