Formula for if Blank

Hi,

I am trying to get the formula to return "Report not Received" when a cell is left blank. I have tried numerous was and am not receiving the result I am looking for.

It will either return a "Report Received by Deadline" or will remain blank.

Here is the current formula:

=IF(NOT(ISBLANK([January '22]@row)), IF([January '22]@row > DATE(2022, 1, 31), "Report Received After Deadline", IF([January '22]@row <= DATE(2022, 1, 31), "Report Received by Deadline")))

Find more posts tagged with

Accepted answers

All comments

Christian G.

=IF(NOT(ISBLANK([January '22]@row)),IF([January '22]@row > DATE(2022, 1, 31),"Report Received After Deadline",IF([January '22]@row <= DATE(2022, 1, 31),"Report Received by Deadline")),"Report not Received")

In your initial If statement, you are defining what to do when the cell is "Not Blank", but you forgot to tell what to do when the cell is blank. Here is another way to write the same formula:

=IF(ISBLANK([January '22]@row),"Report not Received",IF([January '22]@row > DATE(2022, 1, 31),"Report Received After Deadline",IF([January '22]@row <= DATE(2022, 1, 31),"Report Received by Deadline")))

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.