If/then formula issue

jacquedale

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.

DKazatsky2

Hi @jacquedale,

Try something like this.

=IF(OR([1.1 Product Schedule - Uploaded on EIDA?]@row = "No",[1.3 Drawings]@row = "No",[1.4 Product Data]@row, [2.1 Applicator]@row ="No"),"Fail")

Hope this helps,

Dave