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
Eric Praud (Activ8 Solar Energies) Forum Ambassador
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 ) )