You need to sign in to do that
Don't have an account?
PubNoah
Validation: Picklist Required if Checkbox is selected
Hello,
I am trying to make a field required if a check box is selected. The check box is called "Is_Publisher_Currently_Live__c" and the field is called "AdSize_728x90__c."
Below is what I did. The problem is that the validation is not recognizing the "--None--" value of the picklist, since it is a default addition to the picklist. Please help!
-----
AND(
Is_Publisher_Currently_Live__c,
ISPICKVAL( AdSize_728x90__c, "--None--")
)
-----
Thanks,
Noah
--None-- is really empty. Try that instead.
No, that doesn't work. When I put it in quotes, it does not work, presumably because it is looking for value: "empty" without quotes. When I take it out of quotes, I get an error message saying "Error: Field empty does not exist. Check spelling."
Any other thoughts?
This syntax should work for your validation rule:
AND(
Is_Publisher_Currently_Live__c,
ISBLANK(TEXT(AdSize_728x90__c))
)
Worked! Thanks for your help.