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)))
Help Article Resources
Check out the Formula Handbook template!