Column Validation on Yes/No Ceheckbox

Question

_{Wednesday, April 23, 2014 6:40 PM}

As there is no column validation on a Yes/No column within the column itself, I'm wondering if it's possible at the List level to create column validation on 4 Yes/No columns.

Something like this: allow Checkbox A to be set to Yes if and only if Checkboxes B, C and D are ALL equal to Yes.

=IF(AND([Checkbox B]=TRUE,[Checkbox C]=TRUE,[Checkbox D]=TRUE)),[Checkbox A]=TRUE,FALSE)

Just not exactly sure about the syntax or whether what I'm attempting is even possible.

Thanks in advance for any assistance you might be able to offer.

Dave

All replies (2)

_{Friday, April 25, 2014 3:26 PM ✅Answered}

Hi Dave,

You can use the following validation for your list.

=OR(AND(A=TRUE,AND(B=TRUE,C=TRUE,D=TRUE)),AND(A=FALSE,OR(B=TRUE,C=TRUE,D=TRUE)))

Thanks

Daniel Yang
TechNet Community Support

_{Friday, April 25, 2014 7:35 PM}

Thanks Daniel. It works perfectly. Sometime I'll take a moment to try to understand what you did!

Dave