ISBLANK Formula for Early, On-Time, Late Tasks

Ian Herzing

Hi there,

Thanks in advance for the help.

I would love to be able to have the "Completion" column show as blank if the "Target Release" cell is also blank.

Here's what I have written now:

Somehow I need to be using "ISBLANK" but I am not sure how to nest it.

Thanks so much,

Ian

Find more posts tagged with

Formulas

Accepted answers

Kelly Moore

Hey @Ian Herzing

Try this

=IF(ISDATE([Target Release]@row), IF([Target Release]@row>[End Date]@row, "Late", IF([Target Release]@row=[End Date]@row, "On Time", "Early")))

Will this work for you?

Kelly

All comments

Kelly Moore

Hey @Ian Herzing

Try this

=IF(ISDATE([Target Release]@row), IF([Target Release]@row>[End Date]@row, "Late", IF([Target Release]@row=[End Date]@row, "On Time", "Early")))

Will this work for you?

Kelly

Ian Herzing

@Kelly Moore - You're actually the BEST - this worked perfectly, tysm.

Kelly Moore

You're kind. I'm glad it worked for you

Kelly

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.