I need to create a formula field that displays a region depending on what country is selected in a picklist (HQ_country__c). I've built the below but keep getting the error 'Syntax error. Missing ')'. Any help would be appreciated!
CASE(TEXT( HQ_country__c ),
"USA","USA",
"Canada","Canada",
"UK","UK & Ireland",
"Ireland", "UK & Ireland",
"Japan","Japan",
"Australia", "Australia & New Zealand"
"New Zealand", "Australia & New Zealand"
"South Africa", "Africa"
"Botswana", "Africa"
"Malawi", "Africa"
"Mozambique", "Africa"
"Namibia", "Africa"
"Ghana", "Africa"
"Nigeria", "Africa"
"Zimbabwe", "Africa"
"Argentina", "South America"
"Brazil", "South America"
"Chile", "South America"
"Colombia", "South America"
"Peru", "South America"
"Denmark", "Nordic"
"Finland", "Nordic"
"Iceland", "Nordic"
"Norway", "Nordic"
"Sweden", "Nordic"
"France", "Continental Europe"
"Netherlands", "Continental Europe"
"Belgium", "Continental Europe"
"Switzerland", "Continental Europe"
"Lichtenstein", "Continental Europe"
"Luxembourg", "Continental Europe"
"Hong Kong", "Asia exc. Japan"
"China", "Asia exc. Japan"
"Singapore", "Asia exc. Japan"
"Thailand", "Asia exc. Japan"
"Vietnam", "Asia exc. Japan"
"Indonesia", "Asia exc. Japan"
"Malaysia", "Asia exc. Japan"
"India", "Asia exc. Japan"
"South Korea", "Asia exc. Japan"
"unknown","N/A","N/A"
)
You are missing commas after most of your arguments. It should be
CASE(TEXT( HQ_country__c ),
"USA","USA",
"Canada","Canada",
"UK","UK & Ireland",
"Ireland", "UK & Ireland",
"Japan","Japan",
"Australia", "Australia & New Zealand",
"New Zealand", "Australia & New Zealand",
"South Africa", "Africa",
"Botswana", "Africa",
"Malawi", "Africa",
"Mozambique", "Africa",
"Namibia", "Africa",
"Ghana", "Africa",
"Nigeria", "Africa",
"Zimbabwe", "Africa",
"Argentina", "South America",
"Brazil", "South America",
"Chile", "South America",
"Colombia", "South America",
"Peru", "South America",
"Denmark", "Nordic",
"Finland", "Nordic",
"Iceland", "Nordic",
"Norway", "Nordic",
"Sweden", "Nordic",
"France", "Continental Europe",
"Netherlands", "Continental Europe",
"Belgium", "Continental Europe",
"Switzerland", "Continental Europe",
"Lichtenstein", "Continental Europe",
"Luxembourg", "Continental Europe",
"Hong Kong", "Asia exc. Japan",
"China", "Asia exc. Japan",
"Singapore", "Asia exc. Japan",
"Thailand", "Asia exc. Japan",
"Vietnam", "Asia exc. Japan",
"Indonesia", "Asia exc. Japan",
"Malaysia", "Asia exc. Japan",
"India", "Asia exc. Japan",
"South Korea", "Asia exc. Japan",
"unknown","N/A","N/A"
)
