You need to sign in to do that
Don't have an account?
Tina 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 )))
AND(
ISPICKVAL( Primary_Lost_Reason__c , "Other"),
ISBLANK( TEXT( Secondary_Lost_Reason__c )))
Amit Chaudhary 8
Your Validation rule look good . What is the data type of "Secondary_Lost_Reason__c" field ?