Mapping values in a multiselect field
I have a form that gets submitted with a multiselect field, and I want to map the values in that multiselect to other values in a mapping sheet. So if a user submits the form with 'San Fransisco, Paris', the formula would return 'USA, France' based on the mapping table on the lefthand side of my screenshot below.
What is the best way to do this?
Help Article Resources
Check out the Formula Handbook template!