Skip to main content
Topics#Data ManagementPergunta de Danielle Dube
Danielle Dube (Exosite) perguntou em #Data Management
26 de abr. de 2016, 16:13

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 respostas
  1. Vinay Chaturvedi (Dazeworks - An iLink Digital Company)
    26 de abr. de 2016, 16:17

    Try this :

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

     

     
Escrever uma resposta...
0/9000