You need to sign in to do that
Don't have an account?
Lukasz 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
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
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
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
Thank you for help. Formula is working perfectly!!!