How we can create a dependant drop down list

Otman ✭✭
edited 10/25/21 in Formulas and Functions

I have a form that is filled up by my colleges asking for a new project, and i have two drop down lists on it :

1. The location of the person filling the request ( Drop dowm list with a unique choice)

2. Others locations that my benificts or concerned by this project ( Drop down of multiples choises)

I would like to avoid repetition on these two drop down lists. When someone select his location from the first drop down list, he should note be able to reselect his location again on the second drop down list, could you please help on that, i guighly appreciate in advance


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!