Help with IF, OR, NOT, ISBLANK

Hello, I'm trying to get it to check these columns and if even one of them is not blank, then populate "1" into the column:

=IF(OR(NOT(ISBLANK([WHS: Enter Date Received]@row)), NOT(ISBLANK([WHS: Enter Lot]@row)), NOT(ISBLANK([IQA: Inspector Email]@row)), 1, 0))

I keep getting the #incorrect argument error....

Any tips?

Thanks in advance!

Find more posts tagged with

Formulas

Accepted answers

All comments

Michael Culley

I would just do:

=if(or([WHS: Enter Date Received]@row<>"",[WHS: Enter Lot]@row<>"",[IQA: Inspector Email]@row<>""),1,0)

Michael Culley

Also I think the only issue with how you did it was the last 2 ))

I think you need to end your formula like this: ([IQA: Inspector Email]@row))), 1, 0)

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.