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
LeboLebo 

Stage Duration in Formulas for Workflow Rules?

I'm new to this & hopefully somebody can help me.  I'm trying to write a formula to trigger an email reminder when an opportunity reaches a certain stage & then has been in that stage for over 60 days.  Have any of you written formulas like this before?

Cool_DevloperCool_Devloper

You have to create a workflow rule of type "when record is created or did not prev met the criteria" on the oppty object.

Here, you can mention the entry criteria as per the stage of the opp record. Then create a time trigger specifying criteria as 60 days after the rule trigger date.

Then create a "send email" action and attach that to the time trigger!

Cool_D
LeboLebo
Unfortunately, there are no time dependent trigger filters so a formula must be written to solve my problem.  Do  you know the formula I would use? 
Cool_DevloperCool_Devloper

You can use "Ischanged(Field)" function (to check if value of stage has changed) and check if the current value of the stage is "value".

With a combination of this, your workflow should be triggered!

Cool_D