+ Start a Discussion

Add a country to formula

This formula does work here for the State field:

IF(OR(ISBLANK(State)), "",
IF(CONTAINS("Hawaii:Alaska", State),"Pacific",

How do I add the COUNTRY field?  I want to add this line but the formula fails:

IF(CONTAINS("Australia:New Zeland", Country ), "APAC",
Ranjeet Singh (SFDC Developer)Ranjeet Singh (SFDC Developer)
Hi Samantha,

Can you please try following formula:
IF(CONTAINS(Country,"Australia:New Zeland"), "APAC","Other")

Some Consideration:
- Country must be API Name of the Country field on object

if Country field hold Australia:New Zeland  value in sequence then field will populate with APAC, therewise Other

Please let me know if you find any issue.

Thanks & Regards,
Ranjeet Singh

Ranjeet Singh (SFDC Developer)Ranjeet Singh (SFDC Developer)
if Country  field is multi-select picklist then use :

IF(INCLUDES(Country,"Australia:New Zeland"), "APAC","Other")