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

svs
  • 11
  • 1
  • 5
  • 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

1 Answers1

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])))
tsap
  • 465
  • 4
  • 13