You need to sign in to do that
Don't have an account?
Robert Wynter
Workflow rule using formula criteria to update fields
I'm using a formulas to verify if 2 fields have changed from specific values to specific values. When I applied it to 1 field it works. I'm having trouble verifying 2 fields in the formula. Can I please get help tweaking this formula below. I want that if both Status__c and Approval_Progres__cc are changed from New to Active/Approved:
AND(
ISPICKVAL(PRIORVALUE(Status__c),'New'),
ISPICKVAL(Status__c, "Active") && ISPICKVAL(PRIORVALUE(Approval_Progress__c),'New'),
ISPICKVAL(Status__c, "Approved"))
AND(
ISPICKVAL(PRIORVALUE(Status__c),'New'),
ISPICKVAL(Status__c, "Active") && ISPICKVAL(PRIORVALUE(Approval_Progress__c),'New'),
ISPICKVAL(Status__c, "Approved"))
& if Status = Approved.
All Answers
if you want both Status and Approval progress changes from new to Active/Approved please use below formula.
if you want either of them change then use below formula
Thanks,
Debasis
& if Status = Approved.