Skip to main content
Topics#Data ManagementPergunta de Marisa Grimes
Marisa Grimes perguntou em #Data Management
17 de out. de 2017, 14:20

Picklist Validation Rule - If Status is Completed then Required Departments must equal Not Applicable or Completed

AND(

 

OR(

 

 ISPICKVAL( RFP_Management__c , "Completed"),

 

 ISPICKVAL( RFP_Management__c , "Not Applicable"),

 

 ISPICKVAL( Series_24_COO_Approval__c , "Completed"),

 

 ISPICKVAL( Series_24_COO_Approval__c , "Not Applicable")

 

 ISPICKVAL( Accounting__c , "Completed"),

 

 ISPICKVAL( Accounting__c , "Not Applicable"),

 

 ISPICKVAL( Legal__c , "Completed"),

 

 ISPICKVAL( Legal__c , "Not Applicable"),

 

 ISPICKVAL( Status__c , "Completed"))) - IS THIS WHAT I NEED HELP WITH

 

RFP_Management__c, Series_24_COO_Approval__c, Accounting__c, Legal__c  equal  Completed or Not Applicale in order for user to change status to Completed.
3 respostas
  1. Steve Molis (You Owe Me a Beer, Inc.)
    17 de out. de 2017, 15:15
    Can you elaborate on whet you're trying to do? 

     

    Are you looking for something like this?

     

     

    AND(
    TEXT( Status__c ) = "Completed",
    OR(
    CASE( RFP_Management__c, 
    "Completed", 1,
    "Not Applicable",1,
    0) = 0,
    CASE( Series_24_COO_Approval__c , 
    "Completed",1,
    "Not Applicable",1,
    0) = 0,
    CASE( Accounting__c , 
    "Completed", 1,
    "Not Applicable", 1,
    0) = 0,
    CASE( Legal__c , 
    "Completed", 1,
    "Not Applicable",1,
    0) = 0
    )
    )

     

     
Escrever uma resposta...
0/9000