function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Nicole Chang_Nicole Chang_ 

Push Counter

Hello everyone, 
Following some doc to create the formula for push counter to calculate how many times a sales rep changes the Closed date on an opportunity to a date farther out, formula as below: 
IF( CloseDate > PRIORVALUE( CloseDate ), IF (MONTH(CloseDate) <> MONTH(PRIORVALUE( CloseDate )) , TRUE, FALSE), FALSE)
Does anyone know if any formula to count the push when opportunity is on "Negotiation" stage for example please? (as I do not want to track close date changes when opportunity is on early stages). TIA
Best Answer chosen by Nicole Chang_
PriyaPriya (Salesforce Developers) 
Hey Nicole,

Try this below :- 
IF( CloseDate > PRIORVALUE( CloseDate )&& ISPICKVAL(Stagename, "Negotiation"), IF (MONTH(CloseDate) <> MONTH(PRIORVALUE( CloseDate )) , TRUE, FALSE), FALSE)

Thanks!

All Answers

PriyaPriya (Salesforce Developers) 
Hey Nicole,

Try this below :- 
IF( CloseDate > PRIORVALUE( CloseDate )&& ISPICKVAL(Stagename, "Negotiation"), IF (MONTH(CloseDate) <> MONTH(PRIORVALUE( CloseDate )) , TRUE, FALSE), FALSE)

Thanks!
This was selected as the best answer
Nicole Chang_Nicole Chang_
perfect!! thanks so much Priya