Skip to main content
Topics#Data ManagementDanielle Dube's Question
Danielle Dube (Exosite) asked in #Data Management
Apr 26, 2016, 4:13 PM

I need to create a validation rule for a lookup field based on the values set in a picklist field.

AND( 

 

ISPICKVAL(LeadSource , "Partner - Indirect Sales"), 

 

ISPICKVAL(LeadSource , "Partner - Dev Kit"), 

 

ISBLANK( Partner_Account__c ))

 

I would like the Partner account field to be required only when these parnter values are selected.  Right now, it does not trigger at all.  If I place an OR formula into this rule: 

 

AND( 

 

​OR(

 

ISPICKVAL(LeadSource , "Partner - Indirect Sales"), 

 

ISPICKVAL(LeadSource , "Partner - Dev Kit"), 

 

ISBLANK( Partner_Account__c )))

 

It will trigger regardless of the picklist value selected.  What am I missing here?
3 answers
  1. Vinay Chaturvedi (Dazeworks - An iLink Digital Company)
    Apr 26, 2016, 4:17 PM

    Try this :

    AND(
    OR( 
    ISPICKVAL(LeadSource , "Partner - Indirect Sales"), 
    ISPICKVAL(LeadSource , "Partner - Dev Kit")
    ), 
    ISBLANK( Partner_Account__c ))

     

     
Write an answer...
0/9000