All, I am going crazy with this VR that is not triggering correctly.
It was working until I added the Created By ID. All I want is to exclude one person from triggering the alert. What am I doing wrong?
ISPICKVAL( Type , "Call/Meeting - Discovery")
&&
ISBLANK( Why_Prospect_Agreed_To_Meet__c )
&&
OR(ISNEW(),
CreatedDate > DATETIMEVALUE("2020-07-31 12:00:00")
)
&&
CreatedById <> "0053a00000O2Mzx"
3 respuestas
Also don't mix AND/OR and && || in the same Formula, just pick one
And don't use hard coded IDs
AND(
$User.Username <> "userX@your.org",
ISPICKVAL( Type , "Call/Meeting - Discovery"),
ISBLANK( Why_Prospect_Agreed_To_Meet__c ),
OR(
ISNEW(),
CreatedDate > DATETIMEVALUE("2020-07-31 12:00:00")
)
)