Skip to main content
Topics#Data ManagementDanielle Dube의 질문
Danielle Dube (Exosite) 님이 #Data Management에 질문했습니다
2016년 4월 26일 오후 4: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개
  1. Vinay Chaturvedi (Dazeworks - An iLink Digital Company)
    2016년 4월 26일 오후 4:17

    Try this :

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

     

     
답변을 작성하세요...
0/9000