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
Lukasz PiziakLukasz Piziak 

Formula on Workflow Rule criteria (ISCHANGED?)

Hello,

I need asistance with creation workflow rule formula for the following scenario:

Formula should return TRUE only when Status field (picklist) was changed from value "Placed on Purchase Order" to value "Approved"
My question: Is it possible to create a formula which will work only with these specific status values?

Thank you for any advise.
Regards
Lukasz
Best Answer chosen by Lukasz Piziak
Nevlyn DSousa TicloNevlyn DSousa Ticlo
Hi Lukasz,

This is possible in a workflow rule

Set the evaluation criteria to 'when a record is created, and every time it's edited'

Then you can set the Rule Criteria to
ISChanged(Status) && ISPICKVAL(Status,'Approved') && ISPICKVAL( PRIORVALUE(Status),'Placed on Purchase Order')

Let me know if this works for you

All Answers

Nevlyn DSousa TicloNevlyn DSousa Ticlo
Hi Lukasz,

This is possible in a workflow rule

Set the evaluation criteria to 'when a record is created, and every time it's edited'

Then you can set the Rule Criteria to
ISChanged(Status) && ISPICKVAL(Status,'Approved') && ISPICKVAL( PRIORVALUE(Status),'Placed on Purchase Order')

Let me know if this works for you
This was selected as the best answer
Lukasz PiziakLukasz Piziak
Hi Nevlyn,

Thank you for help. Formula is working perfectly!!!