Skip to main content

I try a implement this validation rule but i have an error"picklist not supported"

AND( Account__r.Country__c  <> "New Zealand", Account__r.Country__c <> "Australia", Account__r.Country__c <> "Finland", Account__r.Country__c <> "Hong Kong", Account__r.Country__c <> "Italy", Account__r.Country__c <> "Singapore", Account__r.Country__c <> "Turkey", Account__r.Country__c <> "UK", ISCHANGED(  Website_URL__c  ) )

 

Does someone have an idea what i am missing 

 

Thanks in advance 

 

#Sales Cloud  #Service Cloud

2 个回答
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    2022年2月11日 09:06

    Hi Amin,

     

    If Country__c is a picklist, you need to wrap it in TEXT().

    Having said that, you could also go with a CASE function to shorten the formula and this does not require the TEXT() function:

    AND(CASE(Account__r.Country__c ,

    "New Zealand",1,

    "Australia",1,

    "Finland",1,

    "Hong Kong",1,

    "Italy",1,

    "Singapore",1,

    "Turkey", 1,

    "UK",1,0)=0,

    ISCHANGED( Website_URL__c ) )

0/9000