function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Terry_0101Terry_0101 

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")