function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Help with a formula


Can someone please help me with a formula.

What i want to achieve is:


If a case status is set to "Pending" when the status is changed to "Working" add together the due date field and the amount of days that the case has been "Pending"


Does that make sense and is it possible?


Many Thanks

Jake GmerekJake Gmerek

Basically, you need a workflow rule for this.  Your criteria would be something like this:


AND( PRIORVALUE(status) = "Pending", status="working")


and then you could do a field update to add the dates together:


DueDate + (Today() - Date_to_pending__c)


I am assuming that you have a field somewhere that records the date that the status was set to pending.  You will need that as well.


If you need more clarification let me know.



Hi Jake,


Thank you for your help, unfortunately it does not like that formula and says that PRIORVALUE cannot be used for this type - very confusing


You need to set the worfklow to


Every change a record is created or edit.