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


  • It was my understanding that column validation could not reference other columns Commented Sep 17, 2013 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
    Commented Sep 18, 2013 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. Commented Sep 18, 2013 at 15:15

1 Answer 1


At least one can be selected:


Both must be selected:


Only one can be selected:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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