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.
Best Answer
-
@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?
Answers
-
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?
-
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?
-
@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?
-
Thanks for your help. It works π
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!