IF AND ISBLANK formula

I need my formula to read:

IF the Comments Log Received is BLANK,

AND the Approval Status = "All Comments Resolved"

THEN calculate NETDAYS between Date Submitted and All Comments Resolved

This is what I have come up with. However it fails.

=IF(AND(ISBLANK([Comments Log Received]@row), ([Approval / Status]@row = "All Comments Resolved")), NETDAYS([Date Submitted to SJTA]@row, [All Comments Resolved Date]@row)))

Thanks.

Find more posts tagged with

Formulas

Accepted answers

ker9

@SJTA (using this tag generates a notification)

Perhaps I'm not completely understanding, but this is a screenshot of what I thought your first question was asking for - the number of days between two dates if Comment is blank and Approval/Status = All Comments Resolved:

I added "na" to my formula if Comments is not blank to demonstrate.

=IF(AND(ISBLANK([Comments Log Received]@row), ([Approval / Status]@row = "All Comments Resolved")), NETDAYS([Date Submitted to SJTA]@row, [All Comments Resolved Date]@row), "na")

Are you asking for it to be the opposite - only generate NetDays if Comments is not blank?

All comments

ker9

Hi @SJTA

I think you have one too many parenthesis at the end of your formula - instead of 3 try 2.

=IF(AND(ISBLANK([Comments Log Received]@row), ([Approval / Status]@row = "All Comments Resolved")), NETDAYS([Date Submitted to SJTA]@row, [All Comments Resolved Date]@row))

Does that help?

SJTA

Hi,

That does not solve the problem. The result is a blank cell.

I thought my issue would be the order in which I have the IF, AND, and ISBLANK.

I need the formula to confirm the blank cell first and then calculate the date difference based on the values in 2 other cells.

If Cell A is BLANK, the value of cell B is 777 and the value of cell C is 999, what is the difference between cells D and E?

ker9

@SJTA (using this tag generates a notification)

I added "na" to my formula if Comments is not blank to demonstrate.

=IF(AND(ISBLANK([Comments Log Received]@row), ([Approval / Status]@row = "All Comments Resolved")), NETDAYS([Date Submitted to SJTA]@row, [All Comments Resolved Date]@row), "na")

Are you asking for it to be the opposite - only generate NetDays if Comments is not blank?

SJTA

Thanks for your help. It works 🙂

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.