If/Or

Hello,

I am trying to create a flag function based on two Date columns. I want the Flag to go up if either the Date 1 or Date 2 column.

I have unsuccessfully tried: IF(OR([Date 1]@row), "Blank", ([Date 2]@row), "Blank", "Flag", "Unflag")

should I be using numbers instead of "Blank"?

Thank you

Find more posts tagged with

Accepted answers

Kelly Moore

Hey @Sarah Salazar

My personal preference is to designate a blank cell using the double double-quote characters because it’s less typing and I don’t have to keep up with parentheses. Otherwise, you must use the ISBLANK() function. I’ll write your formula both ways.

Flags are turned ON and OFF like checkboxes using zereos and ones. Numbers are not enclosed with quotes.

=IF(OR([Date 1]@row=“”, [Date 2]@row=“”, 1)

=IF(OR(ISBLANK([Date 1]@row), ISBLANK([Date 2]@row)), 1)

Does that work for you?

Kelly

All comments

Kelly Moore

Hey @Sarah Salazar

Flags are turned ON and OFF like checkboxes using zereos and ones. Numbers are not enclosed with quotes.

=IF(OR([Date 1]@row=“”, [Date 2]@row=“”, 1)

=IF(OR(ISBLANK([Date 1]@row), ISBLANK([Date 2]@row)), 1)

Does that work for you?

Kelly

Sarah Salazar

Thank you @Kelly Moore the second one worked perfectly. I appreciate your explanation. Thank you so much!

Kelly Moore

Oops, I forgot the closing OR parenthesis in my first one- that's the challenge of typing on the cellphone.

=IF(OR([Date 1]@row=“”, [Date 2]@row=“”), 1)

Glad one of them worked first try

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.