To count the number of unchecked boxes I'm using the formula: =COUNTIF([% Complete]3:[% Complete]60, 0). The issue is that it is also counting blank rows. How do I get it to only count actual blank checkboxes?
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