Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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??

share|improve this question

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.

share|improve this answer
    
I just suggest and as I feel it makes it easier to read, but as Ranjoe shows it is not needed. –  Robert Kaucher Jun 28 '13 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"

share|improve this answer
    
thank you so much! This helped me! –  JenaZ Jul 1 '13 at 14:45
    
can you mark this as answer then? :) –  Ranjoe Santos Jul 3 '13 at 15:14

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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