You need to sign in to do that
Don't have an account?

Email Any Add or Change Except Two Fields
Hey everyone,
I'm trying to get a validation rule that emails the user whenever a record is created or edited, unless it happens to be on either of two fields. I'm still occasionally getting emails when I'm sure these fields are the only thing getting updated. I've selected "Run this rule if the following formula evaluates to true"
I want all fields to cause an email to be sent except when Most_Recent_Email__c or Most_Recent_Good_Lead__c are updated.
AND(
PRIORVALUE(Most_Recent_Email__c) = Most_Recent_Email__c,
PRIORVALUE(Most_Recent_Good_Lead__c) =Most_Recent_Good_Lead__c
)
ISCHANGED(Most_Recent_Email__c),
ISCHANGED(Most_Recent_Good_Lead__c)
))