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
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!