Nested IF function  Ignore Blank Cells
I'm trying to count the number of late tasks in a project plan. The formula I'm using works as long as a row isn't blank. =IF(AND(TODAY() > Finish15, [% Complete]15 < 1), 1, ""). If I drag the formula all the way down the sheet, then the Late Tasks column populates with a 1. How do I write the formula to not include blank rows?
Tags:
Comments

Will you ever have a blank finish? If not, then try this:
=IF(isblank(Finish15),"", IF(AND(TODAY() > Finish15, [% Complete]15 < 1), 1, ""))

That worked. Thanks Mike!

Thanks! Glad I could help!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!