0

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

1

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. – Robert Kaucher Jun 28 '13 at 15:13
0

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? :) – Ranjoe Santos Jul 3 '13 at 15:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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