0

Option__c(picklist) This is picklist field which contains values (Yes/No) and default as Yes. This field(Option__c) should only be mandatory, when the field State__c(multi picklist) has selected as NY.

I have tried a Validation rule, it looks something like this,

1)

  IF( INCLUDES( States__c , "NY"),
   CONTAINS(Text(Option__c),null),FALSE)
  1. IF(CONTAINS(TEXT(Option__c), "YES:NO") , IF( INCLUDES( States__c , "NY"), false, true), false)
    

Both are not working and also not allowing me to save on any conditions. Any suggestion please, Thanks in advance!!!

1
  • 1
    How about AND(ISPICKVAL(State__c, 'NY'), ISBLANK(Option__c))?
    – TSmith
    Jan 5 at 9:35

1 Answer 1

0

Can you try this validation rule.

AND( INCLUDES( States__c ,'NY'), ISBLANK( TEXT( Option__c ) ) )
1
  • Yes, above rule is working. Thanks SaiPraveen and TSmith
    – Tom
    Jan 5 at 11:20

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.