+ Start a Discussion
Jenny FisherJenny Fisher 

I tried to create a workflow rule and email alert when status is changed to pending resolution from pending ops. This is my formula but it is not working.

I tried to create a workflow rule and email alert when status is changed to pending resolution from pending ops on a case object.  This is my formula but it is not working.  Can someone help.

AND
(
ISCHANGED( Status ), PRIORVALUE(Status)= "Pending Ops", ISPICKVAL(Status,"Pending Resolution")
)
kryzkryz
Your formula looks fine. Are you testing your email alert on Sandbox?

If yes try checking your Deliverability settings in the Setup. Type "Deliverability " in the quick find textbox in the setup then

check if Access level is set to All Email then try testing again.
JustAGirlyGeekJustAGirlyGeek
One other obvious thing to check is to make sure the workflow rule is active.
Jenny FisherJenny Fisher
Thanks everyone.  I am doing this in production and the workflow is active.  I appreciate your feedback in that it's correct.  Is there anything I'm missing that would help.  Nothing is working so I'm so confused.
 
kryzkryz
Forgot that your Status is a picklist field. Your PRIORVALUE needs a little tweak. Try using this one:
 
AND
(
ISCHANGED( Status ), 
TEXT(PRIORVALUE(Status)) = "Pending Ops",
ISPICKVAL(Status,"Pending Resolution")
)