You need to sign in to do that
Don't have an account?
NWhite123
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
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.