You need to sign in to do that
Don't have an account?
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",
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",
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
IF(INCLUDES(Country,"Australia:New Zeland"), "APAC","Other")