Can you combine an If(ISBLANK with OR

The formulas below work independently. I would like them to work together with an OR function to Check a box. Every combination I try is not working.

=IF(ISBLANK(Role@row), 0, 1)

=IF(Level@row <> 2, 0, 1)

Any assistance you can offer is appreciated.

Thank you!

Find more posts tagged with

Accepted answers

Kelly Moore

This one is working consistently on my sheet. Try this

=IF(OR(Role@row = "", Level@row <> 2), 0, 1)

Kelly

All comments

Kelly Moore

Try this

=IF(OR(ISBLANK(Role@row), Level@row <> 2), 0, 1)

Tina

Hi KDM,

I tried the formula. It is accepted but it won't check the box for either part. This one is tricky. If you have any other thoughts please let me know.

Thank you!

Kelly Moore

This one is working consistently on my sheet. Try this

=IF(OR(Role@row = "", Level@row <> 2), 0, 1)

Kelly

Tina

Thanks KDM! I appreciate all your help.

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.