Share via

Calculated Columns for Yes/No columns in Sharepoint

  • Article

Starting from this post​​

let's suppose  that we have following colunms: Col_A, COL_B, COL_C, COL_D and COL_E. All columns are Yes/No Columns. The default value for them it isn't so important ( in calculation columns, Yes value is used as TRUE, and No value as FALSE )

And the request is to show a message in a calculated column ( CALCULATED ) if COL_A is YES and also if one of other columns ( at least one ) is Yes as well. For this calculation, we need a function ( IF ) and 2 logical operator ( AND + OR )

OR will check if one of Col_B, Col_C, Col_D, Col_​D is Yes, and will give the value TRUE in this case

AND will be necesarry to check if all conditions inside it are TRUE - in our case COL_A and OR result

 The last but not least, IF function will show the message based on AND logical value

The correct formula is:

​**=IF(AND(COL_A=TRUE;OR(COL_B=TRUE;COL_C=TRUE;COL_D=TRUE;COL_E=TRUE));"YES";"NO")**

( for on-prem env , maybe you should change ";" to ",", like this

=IF(AND(COL_A=TRUE,OR(COL_B=TRUE,COL_C=TRUE,COL_D=TRUE,COL_E=TRUE)),"YES","NO")
)

This article,is present also on my blog