If with dropdown list

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
-
Hi Seeble,
Unfortunately, it's not possible at the moment, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment.
Hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks Andree! I submitted the request.
-
Excellent!
Happy to help!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
An option (possibly) would be to switch it around. Select the country and the region automatically populates. Would something like that work?
Help Article Resources
Categories
Check out the Formula Handbook template!