Skip to main content
Topics#Data ManagementDomanda di Davina Hanchuck
Davina Hanchuck (SGI, Tampa User Group Co-Leader) ha fatto una domanda in #Data Management
24 gen 2012, 21:14

Worflow formula, use two values of a picklist

I'm trying to write a formula that says:

 

Trigger workflow if it is this record type, has moved from In Approval status to Active and is a subscription type of Gold or Platinum.

 

Below is what I have, the syntax check out fine, but it's not working. What am I doing wrong??

 

AND( $RecordType.Name = "WebSource Contract", ISPICKVAL(PRIORVALUE(Status), "In Approval Process"), ISPICKVAL(Status, "Active"), (ISPICKVAL( Subscription_Type__c , "Gold")), OR(ISPICKVAL( Subscription_Type__c , "Platinum")))

 

Thanks in advance for the feedback!!
7 risposte
  1. Steve Molis (You Owe Me a Beer, Inc.)
    24 gen 2012, 21:23
    AND($RecordType.Name

    = "WebSource Contract", 

    ISPICKVAL(PRIORVALUE(Status), "In Approval Process"), 

    ISPICKVAL(Status, "Active"), 

    OR(

    ISPICKVAL(Subscription_Type__c , "Gold"), 

    ISPICKVAL(Subscription_Type__c , "Platinum")))

Scrivi una risposta...
0/9000