Conditional Drop-Down lists?
Is there a way to create a conditional drop-down list without using a form, and only using a sheet? We do not have the license level to create a data table.
Example:
Product selected from first list (one column): Internet Access
Internet Access type selected from second drop-down list (second column): Fiber Dedicated, Coax, etc.
Answers
-
The only way to "accomplish" this would be to have the separate dropdown columns for each of the first choices and then use conditional formatting to gray out the cells that are not applicable based on the selection.
-
bummer. thank you!
-
Conditional drop-down lists seems like something a lot of users are asking for, and would be top of the list on Smartsheet's product backlog. Any potential dates for when this functioanlity would be released?
Help Article Resources
Categories
Check out the Formula Handbook template!