Complete Subscription
Complete
Core Subscription
Core
Advanced Subscription
Advanced
I would like to create a work flow formula to trigger an email when the value is Complete Subscription OR Complete and changes TO Core Subscription OR Core OR Advanced Subscription OR Advanced
AND I want it to trigger when the value is Core Subscription OR Core OR Advanced Subscription OR Advanced and changed TO Complete Subscription OR Complete
Any advice is appreciated!!
**Formula Novice
Davina
6 个回答
oops. misplaced some brackets. OR(
ISPICKVAL(PRIORVALUE(MyField__c), "Complete Subscription"),
ISPICKVAL(PRIORVALUE( MyField__c ), "Complete")
)
&&
OR(
ISPICKVAL( MyField__c , "Core Subscription"),
ISPICKVAL( MyField__c , "Core"),
ISPICKVAL( MyField__c , "Advanced Subscription"),
ISPICKVAL( MyField__c , "Advanced")
)
