Formula Help

Jason1000

New to SS and have been going through all the previous discussion here and haven't been able to figure this out, hoping someone can help.

I have an inspection form with multiple columns that I want to summarize in one column. If its "Fail" I want it to return "Fail" if not, "Pass". I've got that part working, but the issue is if the cell is blank it still returns pass. I want it to be "N/A" if blank (Row 1 vs row 2-5). I'm thinking this is some kind of nested IF formula?

Adam Murphy

Ok, try again… =IF(OR([Boom
Lift_Hoses, Belts, Tires]@row = "Fail", [Boom, Lift_fluid Leaks]@row =
"Fail", [Boom Lift_Manuals, Labels, Platform Condition]@row = "Fail", "FAIL", IF(OR([Boom Lift_Hoses, Belts, Tires]@row = "", [Boom, Lift_fluid
Leaks]@row = "", [Boom Lift_Manuals, Labels, Platform Condition]@row =
"", [Boom Lift_Appearance - General]@row = ""), "N/A", "Pass"))

Adam Murphy

Yes, a nested IF should work. Try something like this…. =IF(OR([Boom Lift_Hoses, Belts, Tires]@row = "", [Boom, Lift_fluid Leaks]@row = "", [Boom Lift_Manuals, Labels, Platform Condition]@row = "", [Boom Lift_Appearance - General]@row = ""), "N/A", IF(OR([Boom Lift_Hoses, Belts, Tires]@row = "Fail", [Boom, Lift_fluid Leaks]@row = "Fail", [Boom Lift_Manuals, Labels, Platform Condition]@row = "Fail", [Boom Lift_Appearance - General]@row = "Fail"), "FAIL", "Pass"))

Jason1000

https://community.smartsheet.com/discussion/comment/438956#Comment_438956

That worked, Thank you!

Jason1000

Ok, new problem. If only one cell in the row is completed, the result is "N/A". The issue is that while doing the inspection, if an item is "Fail" the inspection is terminated and the remaining columns are not completed. So any of the shown conditions should result in "FAIL".

To further complicate this, I like the cell to be green if pass and red if fail.

Adam Murphy

Ok, try again… =IF(OR([Boom
Lift_Hoses, Belts, Tires]@row = "Fail", [Boom, Lift_fluid Leaks]@row =
"Fail", [Boom Lift_Manuals, Labels, Platform Condition]@row = "Fail", "FAIL", IF(OR([Boom Lift_Hoses, Belts, Tires]@row = "", [Boom, Lift_fluid
Leaks]@row = "", [Boom Lift_Manuals, Labels, Platform Condition]@row =
"", [Boom Lift_Appearance - General]@row = ""), "N/A", "Pass"))

Jason1000

https://community.smartsheet.com/discussion/comment/439102#Comment_439102

That did the trick. Thank you!