Skip to main content
Topics#Data ManagementLori Johnson의 질문
Lori Johnson 님이 #Data Management에 질문했습니다
2014년 11월 18일 오후 2:44

Validation rule on mult-level picklist

I have a multi-level picklist that has 17 options, TYPE_C.  I want to make another field ONET_CODE_C required ONLY if the type_c has certain options chosen from the picklist.  Here is what I have for the validation rule but it is not working.  It is making the ONET CODE field required no matter which picklist item is chosen.  I know it must be a simple fix

 

AND(

 

OR(

 

INCLUDES(Type__c,"Work Experience"),

 

INCLUDES(Type__c,"OJT"),

 

INCLUDES(Type__c,"Business Posted Job to PMTC"),

 

INCLUDES(Type__c,"MW posted job to PMTC"),

 

INCLUDES(Type__c,"MW Repost Job"),

 

INCLUDES(Type__c,"Resume Search"),

 

INCLUDES(Type__c,"MW collected resumes"),

 

INCLUDES(Type__c,"MW Collected Job Applications"),

 

INCLUDES(Type__c,"MW pre screened"),

 

INCLUDES(Type__c,"Apprenticeship"),

 

INCLUDES(Type__c,"MW posted job to PMTC"),

 

ISBLANK( ONET_CODE__c)

 

))
답변 3개
  1. Teja Yarlagadda
    2014년 11월 18일 오후 2:53
    Did you have other conditions that you need for the AND? Picklists and Validation rules are a little weird, try using Contains, instead of Includes.
답변을 작성하세요...
0/9000