IF and IS BLANK to check dates

Hi Smartsheet community,

I have three columns: Late (Y/N), Due Date, and Submission Closed Date. In the Late (Y/N), I have a formula to first check if the Due Date has passed the Submission Closed Date. If it is then, "yes" is filled in the Late (Y/N) column. If the Submission Closed Date is blank, then it checks to see if the Due Date has passed today's date. Again, if it is, then "yes" is filled in the column. If not on both checks, it fills "No" in the Late (Y/N) column.

I tried this but I get an #Incorrect Argument error.

=IF(ISBLANK([Submission Closed Date]@row, [Due Date]@row > [Submission Closed Date]@row, [Due Date]@row > TODAY()), "Yes", "No")

I'd appreciate any help.

Thanks,

Glenn

Find more posts tagged with

Accepted answers

Mark Cronk

=IF(AND(ISDATE([Submission Closed date]@row),ISDATE([Due date]@row)), IF( [Due Date]@row > TODAY()), "Yes", IF(ISBLANK([Submission Closed Date]@row), IF([Due Date]@row > today(), "yes", "No")))

Mark

All comments

Mark Cronk

=IF(AND(ISDATE([Submission Closed date]@row),ISDATE([Due date]@row)), IF( [Due Date]@row > TODAY()), "Yes", IF(ISBLANK([Submission Closed Date]@row), IF([Due Date]@row > today(), "yes", "No")))

Mark

Glenn Ige

Hi Mark,

Thanks for your answer. This formula didn't work but it got me thinking and I was able to resolve with this solution -

=IF(OR(ISDATE([Submission Closed Date]@row) > ISDATE([Due Date]@row), AND(ISBLANK([Submission Closed Date]@row), TODAY() > [Due Date]@row)), "Yes", "No")

I appreciate your help.

Glenn

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.