Skip to main content
Topics#Data ManagementBrandon Jensen's Question
Brandon Jensen asked in #Data Management
May 25, 2017, 7:11 PM

Help with custom formula to trigger an email alert

Can someone help with this formula.. 

 

I'd like an alert when any of these fields change when another field isn't blank.. 

 

AND(  

 

OR (  

 

ISCHANGED ( Classification__c ),  

 

ISCHANGED ( On_Contract__c ),  

 

ISCHANGED ( Target_Customer__c ),  

 

ISCHANGED ( Niche_Customer__c ),  

 

ISCHANGED ( CS_Accepted__c ),  

 

ISCHANGED ( TickerSymbol ),

 

OR(  

 

AND(  

 

NOT (ISBLANK ( Stitch_ID__c))))))
3 answers
  1. Deepak K Anand (‎‎‎‎‎‎Zoom Communications, Inc.)
    May 25, 2017, 7:14 PM
    So like this = 

     

    1. When any of these fields change

    OR(
        ISCHANGED(Classification__c),
        ISCHANGED(On_Contract__c),
        ISCHANGED(Target_Customer__c),
        ISCHANGED(Niche_Customer__c),
        ISCHANGED(CS_Accepted__c),
        ISCHANGED(TickerSymbol)
    )

     

    2. When another field isn't blank

    NOT(ISBLANK(Stitch_ID__c))

     

    Now combine them in an AND - 

    AND(
        [1],
        [2]
    )

     

    So that yields = 

    AND(
        OR(
            ISCHANGED(Classification__c),
            ISCHANGED(On_Contract__c),
            ISCHANGED(Target_Customer__c),
            ISCHANGED(Niche_Customer__c),
            ISCHANGED(CS_Accepted__c),
            ISCHANGED(TickerSymbol)
        ),
        NOT(ISBLANK(Stitch_ID__c))
    )
Write an answer...
0/9000