Drop down list dependent on the data from other column

John Francis Alita

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

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

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. 

Tony Davidson - SmartSheet Certified User 2016

+1

J. Craig Williams

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

DIV

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.