I am trying to do this
AND(
ISPICKVAL( StageName , "Closed Won"),
ISPICKVAL(Account.Channel__c, "Professional"),
NOT($Profile.Name = "System Administrator"),
OR(
NOT(ISPICKVAL(Account.Credit_Status__c, 'Approved up to £840')),
NOT(ISPICKVAL(Account.Credit_Status__c, 'Fully Approved' ))
))
I want the rule to fire when the stage is Closed Won and Channel is Professional and Profile not Sys Admin and Credit Status is not Approved up to £840 or Fully Approved
It works fine if I have only 1 credit status and no or
5 respostas
AND(
ISPICKVAL(StageName, "Closed Won"),
ISPICKVAL(Account.Channel_c, "Professional"),
$Profile.Name <> "System Administrator",
NOT(
OR(
ISPICKVAL(Account.Credit_Status__c, 'Approved up to £840'),
ISPICKVAL(Account.Credit_Status__c, 'Fully Approved' )
)
)
)
