If with dropdown list

seeble
seeble
edited 12/09/19 in Formulas and Functions

I'm trying to come up with the formula to dropdown only certain countries if chose certain region.

I have two dropdown columns Region and Country

If chose Region EMEA, country dropdown list will show DE, DK, NO

If chose Region APAC, country dropdown list will show JP, SG, IN

If chose Region AMER, country dropdown list will show US, CA, BR

 

Is it even possible?

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!