+ Start a Discussion
666Chicago666Chicago 

Need help with Conditionally-Required Validation Rule

I want to create a validation rule that says when the value for NSP Reason field is "Other" the field "NSP Reason Other" is also filled out.  I can't get my formula below to work.  Any help would be appreciated.
 
AND(ISPICKVAL(NSP_Reason__c, "Other (please explain below)"),   LEN(NSP_Reason_Other__c))
EricBEricB
Looks like the second expression in your AND function is not a TRUE/FALSE statement.  Try adding " = 0 " as shown in red below:

AND(
  ISPICKVAL(NSP_Reason__c, "Other (please explain below)"),  
  LEN(NSP_Reason_Other__c) = 0 )