1

I have two columns within a custom list which are check boxes (yes/no). I need to ensure either one of those check boxes are selected so trying to utilize sharepoint validation settings. It seems like a simple formula but it is not working for me, please help me with this syntax. =IF([checkbox1]='false')AND([checkbox2]='false') --- this returns syntax error

Thanks

  • It was my understanding that column validation could not reference other columns – Eric Alexander Sep 17 '13 at 21:52
  • At list settings level, under validation settings, we can refer any of the columns within that list right? i am trying to put the syntax over there to make sure at least one of those check boxes are selected. – svs Sep 18 '13 at 11:49
  • Ah yes, you can do that at the list level, for some reason I was assuming you were trying at the column level. I don't think you can use the And operator. – Eric Alexander Sep 18 '13 at 15:15
4

At least one can be selected:

=OR([checkbox1],[checkbox2])

Both must be selected:

=AND([checkbox1],[checkbox2])

Only one can be selected:

=AND(OR([checkbox1],[checkbox2]),NOT(AND([checkbox1],[checkbox2])))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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