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.

Find more posts tagged with

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.