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) -
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!!!
AND(ISPICKVAL(State__c, 'NY'), ISBLANK(Option__c))?