If blank OR value, then

Hello everyone,

I am new at creating formulas and can't seem to get this right. I've tried so many ways and I am officially confused. I can get it to work with one criteria but not two.

If value in [Document Status] is blank OR <> "draft then uncheck box

if any other value, check box

Here's one of the formulas I tried =IF(ISBLANK(OR([document status]@row<>“draft”), 0,1))

Thank you in advance for your help!

Find more posts tagged with

Accepted answers

MichaelTCA

Hello @vmoody

You are very close!

Flip a couple things around and:

=IF(OR(ISBLANK([document status]@row),[document status]@row<>"draft"),0,1)

All comments

MichaelTCA

Hello @vmoody

You are very close!

Flip a couple things around and:

=IF(OR(ISBLANK([document status]@row),[document status]@row<>"draft"),0,1)

vmoody

Michael! Thank you SOOO much! I was driving myself crazy trying to figure it out. It works great!😃

MichaelTCA

Perfect! Glad it worked.

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.