I was wondering if anyone has an elegant solution to automatically update a picklist field (territory) based on another free text field (country)
If Country = USA, United States, Canada
Update Territory to North America
I know I can do this via a workflow, but due to the number of countries and territories, it will become 8+ workflows.
The Territory values i’m looking to automate are below.
Aland Islands, Denmark, Estonia, Faroe Islands, Finland, Guernsey, Iceland, Ireland, Isle of Man, Jersey, Latvia, Lithuania, Norway, Sark, Svalbard and Jan Mayen, Sweden, United Kingdom, UK, Scotland, Wales
Albania, Andorra, Bosnia and Herzegovina, Croatia, Gibraltar, Greece, Italy, Republic of Macedonia, Macedonia, Malta, Montenegro, Portugal, San Marino, Serbia, Slovenia, Spain, Vatican City
Austria, Belgium, France, Germany, Liechtenstein, Luxembourg, Monaco, Netherlands, Switzerland
Belarus, Bulgaria, Czech Republic, Hungary, Poland, Moldova, Romania, Russia, Slovakia, Ukraine
USA, US, United States, United States of America, Canada, Bermuda
Colombia, Venezuela, Ecuador, Peru, Brazil, Argentina, Uruguay, Paraguay, Chile, Suriname, Bolivia, Guyana
El Salvador, Costa Rica, Belize, Guatemala, Honduras, Nicaragua, Panama
Cyprus, Syria, Lebanon, Israel, the West Bank, Gaza, Jordan, Iraq, Iran, Saudi Arabia, Yemen, Oman, United Arab Emirates, Qatar, Bahrain, Kuwait, Egypt, Libya.
Algeria, Angola, Benin, Botswana, Burkina Faso, Burundi, Cabo Verde, Cameroon, Central African Republic (CAR), Chad, Comoros, Congo, Democratic Republic of the Congo, Republic of the Cote d'Ivoire, Cote D’Ivoire, Djibout,
Egypt, Equatorial Guinea, Eritrea, Eswatini, Swaziland, Ethiopia, Gabon, Gambia, Ghana, Guinea, Guinea-Bissau, Kenya, Lesotho, Liberia, Libya, Madagascar, Malawi, Mali, Mauritania, Mauritius, Morocco, Mozambique, Namibia, Niger, Nigeria, Rwanda, Sao Tome and Principe, Senegal, Seychelles, Sierra Leone, Somalia, South Africa, South Sudan, Sudan, Tanzania, Togo, Tunisia, Uganda, Zambia, Zimbabwe
India, Pakistan, Bangladesh, Nepal, Sri Lanka, Bhutan, and the Maldives
Afghanistan, Armenia, Azerbaijan, Bhutan, Brunei, Cambodia, China, Cyprus, Georgia, Indonesia, Japan, Jordan, Kazakhstan, Kyrgyzstan, Laos, Lebanon, Malaysia, Maldives, Mongolia, Myanmar, Burma, Nepal, North Korea, Oman, Philippines, Russia, Singapore, South Korea, Taiwan, Tajikistan, Thailand, Timor-Leste, Turkey, Turkmenistan, Uzbekistan, Vietnam
Northern Mariana Islands, the Federated States of Micronesia, Fiji, French Polynesia, Kiribati, the Marshall Islands, Nauru, New Caledonia, New Zealand, Palau, Solomon Islands, Tonga, Tuvalu, Vanuatu, Wallis, Futuna