+ Start a Discussion
Sachin Kumar 34Sachin Kumar 34 

Approval Formula/Criteria required

I need to set the 3 different condition into my approval process
If Opportunity : Stage (If stage = Offer/POC or Stage = 5-Contracts)  à Approval is required
If any changes into the closed date         à   Approval is required
If any changes into  the TOTAL (i.e)           à Approval is required 
I had Field Name TOTAL
Currently my TOTAL = 10$
Now in the record, I had changed the TOTAL = 1010$ (If the new new TOTAL value is > 1000$ (i.e. the difference between Old TOTAL (10$) and the New TOTAL (1010$) greater than (>) 1000$) --> the approval process will work.
 
In the same case If TOTAL = 1010$
Now in the same record I had changed the TOTAL = 10$ (If the new TOTAL is 10$ (i.e. the difference between New TOTAL (10$) and the Old TOTAL (1010$) less than (<) 1000$) --> the approval process will work. Remember, I have only one field TOTAL.
For me (1) & (2) is working, unable to set the criteria for the (3) -> For TOTAL condition
 
(Opportunity: StageEQUALS3 - Offer/POC,5 - Contracts) OR (Opportunity: Close DateNOT EQUAL TOTODAY)
William TranWilliam Tran
Make sure you use Formula not criteria:

Your total formula should look like this: feel free to tweak or fix syntax based on actual variable names (like real name for Total__c)

If Opportunity : Stage (If stage = Offer/POC or Stage = 5-Contracts)  à Approval is required
If any changes into the closed date         à   Approval is required -- is the requirement just any changes to close date???
If any changes into  the TOTAL (i.e)           à Approval is required 
 
OR(
Text(StageName) = 'S3 - Offer/POC,5 - Contracts',
ISCHANGED(CloseDate),
AND(ISCHANGED(Total__c),ABS(Total__c - PRIORVALUE(Total__c) )>1000)
)

As a common practice, if your question is answered, please choose 1 best answer. 
But you can give every answer a thumb up if that answer is helpful to you. 

Thanks

Thx
Sachin Kumar 34Sachin Kumar 34
Hi William,

I am getting the below error, while using your above code

Error: Function ISCHANGED may not be used in this type of formula

Stage Filed -> Picklist
Closed Date -> Date 
Total__C -> Formula (Currency) field