I am trying to improve my SharePOint skills, but really struggling with formulas and calculated values.

First my questions is does it matter if the calculated field is reading dropdown, check box or radio button? I am building a Compliance Checklist that users will answer multiple questions.

I have 4 or 5 columns where the value will be "Not Relevant","Pass" or "Fail" If all 5 display "Pass" and/or "Not Relevant" then I want my caluculated column to display "Pass". If any of the 5 columns display "Fail" then I want my calculated column to display "Fail".

Is this too complex to put into a calculated formula??

2 Answers 2


I would use AND

Create a column of the type calculated as you cannot make a default value for a text column that references other columns.

enter image description here

Then use a formula like this:

=IF( AND( IF(Title="Test",TRUE,FALSE), IF(OtherColumn="Derp",TRUE,FALSE) ), "Pass", "Fail")

Referencing all the columns you need.

  • I just suggest and as I feel it makes it easier to read, but as Ranjoe shows it is not needed. Jun 28, 2013 at 15:13

IF([Column1]="Fail", "Fail", IF([Column2]="Fail", "Fail",IF([Column3]="Fail","Fail",IF([Column4]="Fail","Fail",IF([Column5]="Fail","Fail","Pass"))) ))

in essense i check every column if it fails and if it fails it would return fail else if non of the condition is correct it would result to a "Pass"

  • can you mark this as answer then? :) Jul 3, 2013 at 15:14

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.