How do I implement conditional drop down in smartsheet
I have a Sheet 1 where a user can add a customer and multiple addresses for that customer, Column 1 'Customer Name' and Column 2 'Address'. In Sheet 2 I have a form where a user can select the 'Customer Name' (from Sheet 1) and the 'Address' (from sheet 1). I would like the address options in the form(Sheet 2) to be filtered based on the selected 'Customer Name', meaning if I select customer 1 i should only see addresses for customer 1 to select from.
Thanks in advance for you assistance, other suggestions are welcome. 🙂
Answers
-
Unless you only have a few customers, this is not going to be possible.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!