Use of IF AND OR ISBLANK

I would like to write a statement that writes Pending if true and Complete if false. The criteria for Pending are as follows:

If start date > today, and end date > today or end date is blank (where Start Date and End Date are columns)

Here is the statement I wrote, but I keep getting Incorrect Argument Set.

=IF(AND([Start Date]@row > TODAY(), [End Date]@row > TODAY(), OR(ISBLANK([End Date]@row)), "Pending", "Complete"))

I'm pretty sure 'm not using OR correctly - can someone please help?

I am new to writing embedded statements (self teaching through this forum). Any tips are greatly appreciated!

Thank you!

Find more posts tagged with

Formulas

Accepted answers

Michael Culley

I think you meant to do this:

=IF(OR(ISBLANK([End Date]@row), AND([Start Date]@row > TODAY(), [End Date]@row > TODAY())), "Pending", "Complete")

Michael Culley

That basically states if the end date is blank, make it say "pending", or if the start date AND the end date are greater than Today, make it say "pending", else make it say "Complete".

All comments

Michael Culley

I think you meant to do this:

=IF(OR(ISBLANK([End Date]@row), AND([Start Date]@row > TODAY(), [End Date]@row > TODAY())), "Pending", "Complete")

Michael Culley

That basically states if the end date is blank, make it say "pending", or if the start date AND the end date are greater than Today, make it say "pending", else make it say "Complete".

hjq0772

Thank you so much, it worked!

Michael Culley

Awesome good to hear.

Just know with nested Or/And statements you want to think of whether you want the AND inside the OR, or the other way around.

If you want A and (B or C) That would be IF(AND(A,OR(B,C))

If you want A or (B and C) That would be IF(OR(A,AND(B,C))

Can be a bit confusing but with practice you'll get it.

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.