Skip to main content
Topics#Data ManagementAbby Sisk's Question
Abby Sisk asked in #Data Management
Mar 31, 2016, 2:07 PM

Worflow Formula - Amount Change & Stage Change - Email Alert

I have below formula and I'm trying to work in that the stage of the opportunity also has be Sold, Verbally Sold, Contracted or Renewal and I'm having issues getting my formula to not have a syntax error. 

 

Any help is greated appreciated! 

 

 

AND (
ISCHANGED (Amount__c ),
OR (
ISBLANK (Amount__c),
Amount__c = 0, 
ABS(PRIORVALUE(Amount__c) -
Amount__c) = 250000
)
)

 

 
2 answers
  1. Stephen Noe (Salesforce)
    Mar 31, 2016, 2:49 PM
    AND (
    ISCHANGED (Amount__c ),
    OR(
    ISPICKVAL(Stage, 'Sold'),
    ISPICKVAL(Stage, 'Verbally Sold'),
    ISPICKVAL(Stage, 'Contracted'),
    ISPICKVAL(Stage, 'Renewal')
    )
    OR (
    ISBLANK (Amount__c),
    Amount__c = 0, 
    ABS(PRIORVALUE(Amount__c) -
    Amount__c) = 250000
    )
    )

     

    Give this a try.
Write an answer...
0/9000