Skip to main content
Salesforce

Return to Question

added 30 characters in body
Source Link
TSmith
TSmith
  • 5.1k
  • 1
  • 14
  • 31

Option__cOption__c(picklist) This is picklist field which contains values (Yes/No) and default as Yes. This field(Option__cOption__c) should only be mandatory, when the field State__cState__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)

  2. IF(CONTAINS(TEXT(Option__c), "YES:NO") , IF( INCLUDES( States__c , "NY"), false, true), false)

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

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)

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

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

Source Link
Tom
Tom
  • 23
  • 1
  • 6

Validation Rule for Picklist and Multi picklist

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)

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