brandon.elmer’s Profile

points
51

Is there a way to write a COUNTIF formula to count the rows that do not have any children?  I would like to write a COUNTIFS formula that counts:

1. % Complete is < 1

2. Finish is in the past

3. Row doesn't have any children

I know how to write the first two.  I'm struggling to write the 3rd one

Hi Everyone,

I got a great formula from Customer Success that I thought I would share.  I wanted a way to know if a project was at least 1 week or more behind schedule.  This is what Customer Success gave me:

=COUNTIFS(Finish:Finish, TODAY() <= TODAY(-7), [% Complete]:[% Complete], <>1)

This formula

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 use the formula when counting late tasks:  =IF(ISBLANK(Finish107), "", IF(AND(TODAY() > Finish107, [% Complete]107 < 1), 1, ""))

The issue with this is that it also counts summary tasks which really aren't tasks themselves.  Is there a way to ignore summary tasks so I don't have to manually delete

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