If column A, B & C all show yes then column D should also be yes If column A, B or C shows no then column D should be no

Can somebody help me write a formula for this to use in a SharePoint calculated column?

3 Answers 3


The calculated column D should have the following formula:


enter image description here


enter image description here


If A,B,C are all yes/no columns, then =AND(A,B,C). If this does not work for you, better first check the column type of all the three columns.


Use this validation formula in list settings --> validation settings:

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


Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).

If you don't want to manually enter the value for your [D] column from list forms & wan to create calculated column (not shown on list forms & you cannot change its value manually), use below formula:

=AND([A], [B], [C])

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.