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?

late tasks.PNG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!