Compare column dates only if task is finished

Hello! I'm trying to set up a formula that will allow me to assign a value if my "Date Closed" column is later than "Target Close Date" column ONLY IF the task is complete.

So far, I've been able to get my base formula to work:

=IF([Date Closed]13 > [Target Close Date]13, "Yes", "No")

If the date closed is further out than target closed date, the cell in my "Delayed?" column is marked as "Yes". Otherwise, it's marked as "No". My issue is that even if the "Date Closed" is blank, the cell will be marked as "No".

How can I have the formula assign a blank value if the task is not complete? I have a "% Complete" column as well as a dropdown "Status" column

Find more posts tagged with

Accepted answers

Paul H

@Min

Sorry I was distracted and got you column names mixed up

=IF(ISDATE([Date Closed]@row), IF([Date Closed]@row > [Target Closed Date]@row, "Yes", "No"), "")

If that doesn't work please post a snip of your formula

All comments

Paul H

=IF(ISDATE([Target Date]@row), IF([Date Closed]@row > [Target Date]@row, "Yes", "No"), "")

Min

Thank you Paul for getting to it so quickly! Unfortunately, I'm getting "Unparseable" even after changing the formula to match my columns' names.

Paul H

@Min

Sorry I was distracted and got you column names mixed up

=IF(ISDATE([Date Closed]@row), IF([Date Closed]@row > [Target Closed Date]@row, "Yes", "No"), "")

If that doesn't work please post a snip of your formula

Min

It worked perfectly! Thanks so much :)

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.