=OR(ISBLANK Formaula

Hello,

I am trying to build a =OR(ISBLANK formula into a text box column. Check will display is any cell is blank.

I have the following formula but is displaying #INCORRECT ARGUMENT SET. =OR(ISBLANK([Producer Code(s)]@row, ISBLANK([Servicer AM/AE Codes]@row, ISBLANK([SIC Code]@row, ISBLANK(FEIN@row, ISBLANK([LOB’s to be set up]@row, ISBLANK([BOR Effective Date]@row, ISBLANK([Date Submitted]@row))))))))

I have the same formula in another sheet with other cells and works so I am very lost.

Thank you!!!

Find more posts tagged with

Formulas

Accepted answers

All comments

SteyJ

=OR(ISBLANK([producer code(s)]@row), 
ISBLANK([Servicer AM/AE Codes]@row), 
ISBLANK([SIC Code]@row), ISBLANK(FEIN@row), 
ISBLANK([LOB’s to be set up]@row), 
ISBLANK([BOR Effective Date]@row), 
ISBLANK([Date Submitted]@row))

you can try doing it like this. you'll want to enclose your ISBLANK functions

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.