0

I have two multi picklist fields(A,C) and 1 pick list field(B- yes/no). A has 5 values (1,2,3,4,5) and B has 3 values(7,8,9). If user selects value 1 in A and B pick list value is Yes, user should be able to select 7,8 and save. Subsequently i have different combinations when user selects 1,2,3 in A and b is yes and user should be able to select 7. I know multi pick list supports only few functions like contain, isblank. Is it possible to achieve this via validation rule. Please suggest.

-1

AND(ISPICKVAL(B__c, "Yes"), AND(INCLUDES(A__c, "1"), OR(INCLUDES(C__c, "9")))

For different combinations i have added lot of AND and Includes. Is their any refined logic to keep the combinations simple.

3
  • Is this an answer to your question or is this another question? – Alex Tennant Jul 18 '14 at 9:09
  • this is a follow up question to the initial one. – Venkat Jul 18 '14 at 15:28
  • please edit your original question and delete this answer – cropredy Jul 18 '14 at 17:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.