Hello,

I am trying to create a workflow formula on the account object to have a custom text-field called Region getting updated based on the BillingCountry field value of the account. First tried this with a direct formula field but I red somewhere there are limitations to the number of characters or size of the formula that can be maximum used. However when creating the workflow I still get the error: Error, The size of your string is 4.448 bytes but may not exceed 4.000 bytes.

See formula below which are a lot of nested CASES checking for countries we have in Asia, Latin America and North America and if the country is different it will select Europe (which has most of the countries we use).

Any idea why this does not work? The syntax is correct and I thought with workflow there are no limitations in the formula-size.

Thanks,

Chris


CASE(BillingCountry,  "Afghanistan",  "Asia",  "American Samoa",  "Asia",  CASE(BillingCountry,  "Australia",  "Asia",  "Bangladesh",  "Asia",  
CASE(BillingCountry,  "Bhutan",  "Asia",  "Brunei Darussalam",  "Asia",  CASE(BillingCountry,  "Cambodia",  "Asia",  "China",  "Asia",  
CASE(BillingCountry,  "Cook Islands",  "Asia",  "Fiji",  "Asia",  CASE(BillingCountry,  "French Polynesia",  "Asia",  "Guam",  "Asia",  
CASE(BillingCountry,  "Hong Kong",  "Asia",  "India",  "Asia",  CASE(BillingCountry,  "Indonesia",  "Asia",  "Japan",  "Asia",  
CASE(BillingCountry,  "Kiribati",  "Asia",  "Korea, Democratic People's Republic of",  "Asia",  CASE(BillingCountry,  "Korea, Republic of",  "Asia",  "Lao People's Democratic Republic",  "Asia",  
CASE(BillingCountry,  "Macao",  "Asia",  "Malaysia",  "Asia",  CASE(BillingCountry,  "Maldives",  "Asia",  "Marshall Islands",  "Asia",  
CASE(BillingCountry,  "Micronesia, Federated States of",  "Asia",  "Mongolia",  "Asia",  CASE(BillingCountry,  "Myanmar",  "Asia",  "Nepal",  "Asia",  
CASE(BillingCountry,  "New Caledonia",  "Asia",  "New Zealand",  "Asia",  CASE(BillingCountry,  "Niue",  "Asia",  "Norfolk Island",  "Asia",  
CASE(BillingCountry,  "Northern Mariana Islands",  "Asia",  "Pakistan",  "Asia",  CASE(BillingCountry,  "Palau",  "Asia",  "Papua New Guinea",  "Asia",  
CASE(BillingCountry,  "Philippines",  "Asia",  "Samoa",  "Asia",  CASE(BillingCountry,  "Singapore",  "Asia",  "Solomon Islands",  "Asia",  
CASE(BillingCountry,  "Sri Lanka",  "Asia",  "Taiwan, Province of China",  "Asia",  CASE(BillingCountry,  "Thailand",  "Asia",  "Timor-Leste",  "Asia",  
CASE(BillingCountry,  "Tokelau",  "Asia",  "Tonga",  "Asia",  CASE(BillingCountry,  "Tuvalu",  "Asia",  "Uzbekistan",  "Asia",  
CASE(BillingCountry,  "Vanuatu",  "Asia",  "Viet Nam",  "Asia",  CASE(BillingCountry,  "Wallis and Futuna",  "Asia",  "Antigua and Barbuda",  "Latin America",  
CASE(BillingCountry,  "Argentina",  "Latin America",  "Aruba",  "Latin America",  CASE(BillingCountry,  "Bahamas",  "Latin America",  "Barbados",  "Latin America",  
CASE(BillingCountry,  "Belize",  "Latin America",  "Bermuda",  "Latin America",  CASE(BillingCountry,  "Bolivia",  "Latin America",  "Brazil",  "Latin America",  
CASE(BillingCountry,  "Caribean",  "Latin America",  "Cayman Islands",  "Latin America",  CASE(BillingCountry,  "Chile",  "Latin America",  "Colombia",  "Latin America",  
CASE(BillingCountry,  "Costa Rica",  "Latin America",  "Cuba",  "Latin America",  CASE(BillingCountry,  "Dominica",  "Latin America",  "Dominican Republic",  "Latin America",  
CASE(BillingCountry,  "Ecuador",  "Latin America",  "El Salvador",  "Latin America",  CASE(BillingCountry,  "French Guiana",  "Latin America",  "Grenada",  "Latin America",  
CASE(BillingCountry,  "Guadeloupe",  "Latin America",  "Guatemala",  "Latin America",  CASE(BillingCountry,  "Guyana",  "Latin America",  "Haiti",  "Latin America",  
CASE(BillingCountry,  "Honduras",  "Latin America",  "Jamaica",  "Latin America",  CASE(BillingCountry,  "Martinique",  "Latin America",  "Mexico",  "Latin America",  
CASE(BillingCountry,  "Netherlands Antilles",  "Latin America",  "Nicaragua",  "Latin America",  CASE(BillingCountry,  "Panama",  "Latin America",  "Paraguay",  "Latin America",  
CASE(BillingCountry,  "Peru",  "Latin America",  "Puerto Rico",  "Latin America",  CASE(BillingCountry,  "Saint Kitts and Nevis",  "Latin America",  "Saint Lucia",  "Latin America",  
CASE(BillingCountry,  "Saint Vincent and The Grenadines",  "Latin America",  "Suriname",  "Latin America",  CASE(BillingCountry,  "Trinidad and Tobago",  "Latin America",  "Turks and Caicos Islands",  "Latin America",  
CASE(BillingCountry,  "Uruguay",  "Latin America",  "Venezuela, Bolivarian Republic of",  "Latin America",  CASE(BillingCountry,  "Virgin Islands, British",  "Latin America",  "Virgin Islands, U.S.",  "Latin America",  
CASE(BillingCountry,  "Canada",  "North America",  "United States",  "North America",  "Europe")))))))))))))))))))))))))))))))))))))))))))))))))

Hi

Are there any impacts (in native Salesforce functionality such as report etc) I  should be aware of when changing a master-detail field to a lookup ?

Many thanks
Ross