You need to sign in to do that
Don't have an account?

Workflow rule for field changing to a specific value
I currently have a workflow that triggers if a field (picklist) is updated. The formula is
AND(
NOT(ISNEW()),
ISCHANGED(Hire_Type__c),
NOT(ISBLANK(PRIORVALUE(Hire_Type__c))),
AVTRRT__Terminated__c = false )
I'm looking to create a new workflow that triggers a different email alert when the field is changed to the value Subscription. So I'd like to update the existing formula above to not trigger if the field's new value is Subscription and create a new workflow that triggers only when the field is updated and the new value is Subscription, just not sure what functions will be best.
Help appreciated! =)
AND(
NOT(ISNEW()),
ISCHANGED(Hire_Type__c),
NOT(ISBLANK(PRIORVALUE(Hire_Type__c))),
AVTRRT__Terminated__c = false )
I'm looking to create a new workflow that triggers a different email alert when the field is changed to the value Subscription. So I'd like to update the existing formula above to not trigger if the field's new value is Subscription and create a new workflow that triggers only when the field is updated and the new value is Subscription, just not sure what functions will be best.
Help appreciated! =)
You can try below one:
AND(
NOT(ISNEW()),
ISCHANGED(Hire_Type__c),
NOT(ISPICKVAL(Hire_Type__c, 'Subscription')),
NOT(ISBLANK(PRIORVALUE(Hire_Type__c))),
AVTRRT__Terminated__c = false )
For the second one:
AND(
NOT(ISNEW()),
ISCHANGED(Hire_Type__c),
ISPICKVAL(Hire_Type__c, 'Subscription'),
NOT(ISBLANK(PRIORVALUE(Hire_Type__c))),
AVTRRT__Terminated__c = false )
Please let me know if it helps.
Regards,
Mahesh
All Answers
You can try below one:
AND(
NOT(ISNEW()),
ISCHANGED(Hire_Type__c),
NOT(ISPICKVAL(Hire_Type__c, 'Subscription')),
NOT(ISBLANK(PRIORVALUE(Hire_Type__c))),
AVTRRT__Terminated__c = false )
For the second one:
AND(
NOT(ISNEW()),
ISCHANGED(Hire_Type__c),
ISPICKVAL(Hire_Type__c, 'Subscription'),
NOT(ISBLANK(PRIORVALUE(Hire_Type__c))),
AVTRRT__Terminated__c = false )
Please let me know if it helps.
Regards,
Mahesh
for that use the third criteria
created, and any time it's edited to subsequently meet criteria for the (Hire_Type__c) field