Stop counting blank cells

andhou

Hello,

I want to display whether a project is active or not based on 1) it started in the past and 2) status is anything BUT complete. The issue is that Smartsheet is counting the blank cells and returning a value of yes, it is active. However, I want to have a blank cell return the status of No. I have my formula below, but it's not accounting for blank cells.

=IF(AND([Target Start Date]@row < TODAY(), NOT(Status@row = "Complete")), "Yes", "No")

I would appreciate any advice or help! Thank you in advance!

The status I have are:

Paul H

Try

=IF(ISBLANK(Status@row), "No", IF(AND([Target Start Date]@row < TODAY(), NOT(Status@row = "Complete")), "Yes", "No"))

Paul H

Try

=IF(ISBLANK(Status@row), "No", IF(AND([Target Start Date]@row < TODAY(), NOT(Status@row = "Complete")), "Yes", "No"))

andhou

Thank you Paul! That worked.