Creating a country priority formula

Hi all,

I have an important project for a company I’m working with. We have a list of 14 countries that are important to the client. I was asked to create a priority list. Basically, those 14 countries are the most important ones in the sea of all countries (more than 100 of them), and I have to make a formula which will make these 14 countries the highest in the priority order of other countries. I’m new to Monday, so not really sure where to begin. The code I have now is:

IF(OR({Country}=“France”, {Country}=“Germany”, {Country}=“Greece”, {Country}=“Ireland”, {Country}=“The Netherlands”, {Country}=“Poland”, {Country}=“Spain”, {Country}=“Brazil”, {Country}=“Canada”, {Country}=“Japan” , {Country}=“Mexico”, {Country}=“Philippines” , {Country}=“New Zealand”, {Country}=“South Africa” = TRUE, SWITCH({Priority}, “High”, 3, “Medium”, 2, “Low”, 1, 0) => 3

It’s, of course, giving me an error. It says - A column named “Priority” doesn’t exist in this board. Thank you!

It’s also important to also note that the countries are not written like countries, but are in regions. So - Europe, South America etc. For example:

IF(OR({Country}=“Angola”, {Country}=“Burkina Faso”, {Country}=“Burundi”, {Country}=“Benin”, {Country}=“Botswana”, {Country}=“Congo, The Democratic Republic of the”, {Country}=“Central African Republic”, {Country}=“Congo”, {Country}=“Côte D’Ivoire”, {Country}=“Cameroon”, {Country}=“Cape Verde”, {Country}=“Western Sahara”, {Country}=“Eritrea”, {Country}=“Ethiopia”, {Country}=“Gabon”, {Country}=“Ghana”, {Country}=“Gambia”, {Country}=“Guinea”, {Country}=“Equatorial Guinea”, {Country}=“Guinea-Bissau”, {Country}=“Kenya”, {Country}=“Liberia”, {Country}=“Lesotho”, {Country}=“Madagascar”, {Country}=“Mali”, {Country}=“Mauritius”, {Country}=“Malawi”, {Country}=“Mozambique”, {Country}=“Namibia”, {Country}=“Niger”, {Country}=“Nigeria”, {Country}=“Rwanda”, {Country}=“Seychelles”, {Country}=“South Sudan”, {Country}=“Saint Helena”, {Country}=“Sierra Leone”, {Country}=“Senegal”, {Country}=“Sao Tome and Principe”, {Country}=“Eswatini”, {Country}=“Chad”, {Country}=“Togo”, {Country}=“Tanzania”, {Country}=“Uganda”, {Country}=“Mayotte”, {Country}=“South Africa”, {Country}=“Zambia”, {Country}=“Zimbabwe”) = TRUE,“Africa”, (IF(OR({Country}=“Bahrain”, {Country}=“Djibouti”, {Country}=“Algeria”, {Country}=“Comoros”, {Country}=“Morocco”, {Country}=“Mauritania”, {Country}=“Palestinian Territory”, {Country}=“Sudan”, {Country}=“Somalia”, {Country}=“Tunisia”) = TRUE,“Arab States”, IF(OR({Country}=“Afghanistan”, {Country}=“Antarctica”, {Country}=“American Samoa”, {Country}=“Australia”, {Country}=“Azerbaijan”, {Country}=“Bangladesh”, {Country}=“Brunei Darussalam”, {Country}=“Bhutan”, {Country}=“Cocos (Keeling) Islands”, {Country}=“Cook Islands”, {Country}=“China”, {Country}=“Christmas Island”, {Country}=“Fiji”, {Country}=“Micronesia, Federated States of”, {Country}=“Guam”, {Country}=“Hong Kong”, {Country}=“Heard Island and McDonald Islands”, {Country}=“Indonesia”, {Country}=“India”, {Country}=“British Indian Ocean Territory”, {Country}=“Japan”, {Country}=“Kyrgyzstan”, {Country}=“Cambodia”, {Country}=“Kiribati”, {Country}=“North Korea”, {Country}=“South Korea”, {Country}=“Kazakhstan”, {Country}=“Lao People’s Democratic Republic”, {Country}=“Sri Lanka”, {Country}=“Marshall Islands”, {Country}=“Myanmar”, {Country}=“Mongolia”, {Country}=“Macau”, {Country}=“Northern Mariana Islands”, {Country}=“Maldives”, {Country}=“Malaysia”, {Country}=“New Caledonia”, {Country}=“Norfolk Island”, {Country}=“Nepal”, {Country}=“Nauru”, {Country}=“Niue”, {Country}=“New Zealand”, {Country}=“French Polynesia”, {Country}=“Papua New Guinea”, {Country}=“Philippines”, {Country}=“Pakistan”, {Country}=“Pitcairn Islands”, {Country}=“Palau”, {Country}=“Reunion”, {Country}=“Solomon Islands”, {Country}=“Singapore”, {Country}=“Syrian Arab Republic”, {Country}=“French Southern Territories”, {Country}=“Thailand”, {Country}=“Tajikistan”, {Country}=“Tokelau”, {Country}=“Turkmenistan”, {Country}=“Tonga”, {Country}=“Timor-Leste”, {Country}=“Tuvalu”, {Country}=“Taiwan”, {Country}=“United States Minor Outlying Islands”, {Country}=“Uzbekistan”, {Country}=“Vietnam”, {Country}=“Vanuatu”, {Country}=“Wallis and Futuna”, {Country}=“Samoa”) = TRUE,“Asia & Pacific”, IF(OR({Country}=“Andorra”, {Country}=“Albania”, {Country}=“Armenia”, {Country}=“Austria”, {Country}=“Bosnia and Herzegovina”, {Country}=“Belgium”, {Country}=“Bulgaria”, {Country}=“Belarus”, {Country}=“Switzerland”, {Country}=“Cyprus”, {Country}=“Czech Republic”, {Country}=“Germany”, {Country}=“Denmark”, {Country}=“Estonia”, {Country}=“Spain”, {Country}=“Finland”, {Country}=“Faroe Islands”, {Country}=“France”, {Country}=“France, Metropolitan”, {Country}=“United Kingdom”, {Country}=“Georgia”, {Country}=“Gibraltar”, {Country}=“Greenland”, {Country}=“Greece”, {Country}=“Croatia”, {Country}=“Hungary”, {Country}=“Ireland”, {Country}=“Iceland”, {Country}=“Italy”, {Country}=“Liechtenstein”, {Country}=“Lithuania”, {Country}=“Luxembourg”, {Country}=“Latvia”, {Country}=“Monaco”, {Country}=“Moldova, Republic of”, {Country}=“Macedonia”, {Country}=“Malta”, {Country}=“Netherlands”, {Country}=“Norway”, {Country}=“Poland”, {Country}=“Portugal”, {Country}=“Romania”, {Country}=“Russia”, {Country}=“Sweden”, {Country}=“Slovenia”, {Country}=“Svalbard and Jan Mayen”, {Country}=“Slovakia”, {Country}=“San Marino”, {Country}=“Turkey”, {Country}=“Ukraine”, {Country}=“Holy See (Vatican City State)”, {Country}=“Serbia”, {Country}=“Montenegro”, {Country}=“Aland Islands”, {Country}=“Guernsey”, {Country}=“Isle of Man”, {Country}=“Jersey”) = TRUE,“Europe”, IF(OR({Country}=“United Arab Emirates”, {Country}=“Egypt”, {Country}=“Israel”, {Country}=“Iraq”, {Country}=“Iran, Islamic Republic of”, {Country}=“Jordan”, {Country}=“Kuwait”, {Country}=“Lebanon”, {Country}=“Libya”, {Country}=“Oman”, {Country}=“Qatar”, {Country}=“Saudi Arabia”, {Country}=“Yemen”) = TRUE,“Middle east”, IF(OR({Country}=“Canada”, {Country}=“Saint Pierre and Miquelon”, {Country}=“United States”) = TRUE,“North America”, IF(OR({Country}=“Nicaragua”) = TRUE,“South/Central America”, IF(OR({Country}=“Antigua and Barbuda”, {Country}=“Anguilla”, {Country}=“Netherlands Antilles”, {Country}=“Argentina”, {Country}=“Aruba”, {Country}=“Barbados”, {Country}=“Bermuda”, {Country}=“Bolivia”, {Country}=“Brazil”, {Country}=“Bahamas”, {Country}=“Bouvet Island”, {Country}=“Belize”, {Country}=“Chile”, {Country}=“Colombia”, {Country}=“Costa Rica”, {Country}=“Cuba”, {Country}=“Dominica”, {Country}=“Dominican Republic”, {Country}=“Ecuador”, {Country}=“Falkland Islands (Malvinas)”, {Country}=“Grenada”, {Country}=“French Guiana”, {Country}=“Guadeloupe”, {Country}=“South Georgia and the South Sandwich Islands”, {Country}=“Guatemala”, {Country}=“Guyana”, {Country}=“Honduras”, {Country}=“Haiti”, {Country}=“Jamaica”, {Country}=“Saint Kitts and Nevis”, {Country}=“Cayman Islands”, {Country}=“Saint Lucia”, {Country}=“Martinique”, {Country}=“Montserrat”, {Country}=“Mexico”, {Country}=“Panama”, {Country}=“Peru”, {Country}=“Puerto Rico”, {Country}=“Paraguay”, {Country}=“Suriname”, {Country}=“El Salvador”, {Country}=“Turks and Caicos Islands”, {Country}=“Trinidad and Tobago”, {Country}=“Uruguay”, {Country}=“Saint Vincent and the Grenadines”, {Country}=“Venezuela”, {Country}=“Virgin Islands, British”, {Country}=“Virgin Islands, U.S.”, {Country}=“Saint Barthelemy”, {Country}=“Saint Martin”) = TRUE,“South/Latin America”, “/!\ Fix Region”)))))))))

This is the code for GEO REGION that includes all countries for the South/Latin America, and in the table it is grouped as South/Latin America, not as individual countries. Same as Europe and other regions. Don’t know if that also changes my code above.