Skip to main content
I have a field with 6 values:

 

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 risposte
  1. 23 giu 2011, 16:04
    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")

    )

     

     
0/9000