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
NWhite123NWhite123 

Help with a formula

Hi

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.

 
NWhite123NWhite123

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
InternalServerErrorInternalServerError

You need to set the worfklow to

 

Every change a record is created or edit.