Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have one drop down which cannot be blank and it has blank as default value. I have also one checkbox with value True and if this one is ticked, then the dropdown should be disabled and allow blank. If the checkbox is not ticked then blank value in the dropdown should not be allowed.

I have my rule to disable the dropdown which works fine:

enter image description here

But when I add a validation rule to set it to be required only if it is blank and the checkbox is not equal to True (not checked) then it is always required regardless of whether the checkbox is ticked or not. Rule:

enter image description here

What am I missing here?

Thanks in advance.

share|improve this question
add comment

1 Answer

up vote 0 down vote accepted

I'm guessing your checkbox's field data type is text correct? Can you make sure that when you changed it from boolean (TRUE/FALSE) to text - that it matches the casing of your rules? For instance, when I changed the field to a text type, the Value when checked changed to "true" not "True" like you have in your rules. That may be the problem.

enter image description here

Thanks, -@SharePointAP

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.