If/then formula issue

We are using a form to perform inspections. If any inspection enters contain a "no" to any question it automatically becomes a "fail" for that inspection.

I am trying to build a formula that will calculate a "Fail" if any of the entries in the row are "No". I have tried everything I can find and I am struggling to find a solution.

Here is one of the many I have tried. =IF(CONTAINS("No", [1.1 Product Schedule - Uploaded on EIDA?]@row, [1.3 Drawings]@row, [1.4 Product Data]@row, [2.1 Applicator]@row), "Fail")


TIA for any help.


Jacque Smith

Project Controls, MSR-FSR

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!