Skip to main content
Sole Angel preguntó en #Formulas

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
  1. 14 ene 2022, 18:09

    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")

    )

    )

     

    Also don't mix AND/OR and && || in the same Formula, just pick one And don't use hard coded IDs AND($User.Username <>

0/9000