+ Start a Discussion
Tina Cancino 16Tina Cancino 16 

validation rule evaluation

I wrote the below validation to evaluate when field 'A' is set to 'other' and Field 'B' is empty then alert user that the field be must be populated.  It validates but still does not allow the record to be saved when field 'b' is populated, unsure what I'm missing. Do I need to add another condition when it is populated?

AND(
ISPICKVAL(  Primary_Lost_Reason__c , "Other"),
ISBLANK( TEXT( Secondary_Lost_Reason__c )))
Amit Chaudhary 8Amit Chaudhary 8
Your Validation rule look good . What is the data type of "Secondary_Lost_Reason__c" field ?