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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!