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!!!

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

1 Answer 1

Reset to default
0

Can you try this validation rule.

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .