CASE(
RegisteringCountry
,"Argentina", "India",
"Australia", "India",
"Bangladesh", "Singapore",
"Belgium", "India",
"Bhutan", "Singapore",
"Brunei Darussalam","Singapore",
"Brazil", "India",
"Cameroon", "India",
"Canada", "India",
"Chile", "India",
"China", "Singapore",
"Czech Republic", "India",
"Denmark", "India",
"Egypt", "Singapore",
"England", "India",
"Ethiopia", "Singapore",
"France", "India",
"Germany", "India",
"Greece", "India",
"Hong Kong", "Singapore",
"India", "Singapore",
"Indonesia", "Singapore",
"Iran", "Singapore",
"Ireland", "India",
"Italy", "India",
"Japan", "Singapore",
"Jordan", "Singapore",
"Kenya", "India",
"Kingdom of Saudi Arabia", "Singapore",
"Korea", "Singapore",
"Laos", "Singapore",
"Malaysia", "Singapore",
"Mauritius", "India",
"Morocco", "India",
"Myanmar", "Singapore",
"New Zealand", "New Zealand",
"Nigeria", "India",
"Oman", "Singapore",
"Pakistan", "Singapore",
"Palestine", "Singapore",
"Papua New Guinea", "India",
"Philippines", "Singapore",
"Poland", "India",
"Portugal", "India",
"Russia", "India",
"Saudi Arabia", "Singapore",
"Singapore", "Singapore",
"South Africa", "India",
"South Korea", "Singapore",
"Sri Lanka", "Singapore",
"Sweden", "India",
"Switzerland", "India",
"Taiwan", "Singapore",
"Thailand", "Singapore",
"United Arab Emirates", "Singapore",
"UAE", "Singapore",
"United Kingdom", "India",
"USA", "India",
"Vietnam", "Singapore",
"Zambia", "India", "")
I'm new to Sales Force and have reached the max limit on the field. IS there any way to reduce the size of the code. I was thinking of using if else but can't get it to work.
Thanks for the help.