I have a validation rule to check if a text area has a value or not. Here's my code:
"ISPICKVAL( Status , "Unable to contact") ||
ISPICKVAL( Status , "Long Term Follow-Up") ||
ISPICKVAL( Status , "Unqualified") ||
ISPICKVAL( Status , "Bad Information") ||
ISPICKVAL( Status , "Dead")
&& ISBLANK( Results__c )"
Validating works just fine. But when I populate the field, it still gives me the error. Thoughts??
3 answers
Try this:
AND(
ISBLANK( Results__c ),
OR(
ISPICKVAL( Status , "Unable to contact") ,
ISPICKVAL( Status , "Long Term Follow-Up"),
ISPICKVAL( Status , "Unqualified"),
ISPICKVAL( Status , "Bad Information"),
ISPICKVAL( Status , "Dead")
)
)
