Formula Help
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?
Best Answer
-
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"))
Answers
-
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"))
-
That worked, Thank you!
-
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.
-
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")) -
That did the trick. Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!