Nesting ISBLANK within IF(AND) Statements

Hello,

I have successfully established a formula link between two date columns (Start & Finish) and my 3 status trackers (Completed, In Progress, Not Started). The formula I have used successfully is:

=IF(AND(Start@row > TODAY(), Finish@row > TODAY()), "Not Started", IF(AND(Start@row < TODAY(), Finish@row > TODAY()), "In Progress", IF(AND(Start@row < TODAY(), Finish@row < TODAY()), "Completed")))

Now, however, any columns with blank Start / Finish dates are defaulting to "Completed". I would rather have them default as blank.

I attempted to nest ISBLANK in there as follows:

=IF(AND(Start@row > TODAY(), Finish@row > TODAY()), "Not Started", IF(AND(Start@row < TODAY(), Finish@row > TODAY()), "In Progress", IF(AND(Start@row < TODAY(), Finish@row < TODAY()), "Completed"), IF(ISBLANK(Start@Row), ""))

But that's throwing the your syntax isn't quite right error.

Any recommendations? Thanks all!

Find more posts tagged with

Formulas

Automations

Project Management

Cell linking

Accepted answers

Leibel S

@Sierra G

Try the below:

=IF(ISBLANK(Start@row),"",IF(Start@row > TODAY(), "Not Started", IF(Finish@row > TODAY(), "In Progress", "Completed")))

All comments

Leibel S

@Sierra G

Try the below:

=IF(ISBLANK(Start@row),"",IF(Start@row > TODAY(), "Not Started", IF(Finish@row > TODAY(), "In Progress", "Completed")))

Sierra G

@Leibel Shuchat

It worked! Thank you! You made my week!

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.