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! =)

March 3, 2016
·
Like
0
·
Follow
2

Best Answer chosen by Vicky Pan

Mahesh D
Hi Vicky,

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

March 3, 2016
·
Like
0
·
Dislike
0

This was selected as the best answer

sumit singh 37
you cannot use is change in the workflow
for that use the third criteria
created, and any time it's edited to subsequently meet criteria for the (Hire_Type__c) field

March 7, 2016
·
Like
0
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

Workflow rule for field changing to a specific value

All Answers

You need to sign in to do that.