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
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!