Count of Children Code not working on top row of schedule

delaurellc

I have code that are in all parent rows of a project schedule. This code works on all parent rows but the very top which is the full status of the project. Can you help me figure out why it is working on all other parent rows but the very top of the schedule. All other rows in the schedule are children to this row.

=IF(COUNTIF(CHILDREN(), "Complete") = COUNT(CHILDREN()), "Complete", IF(COUNTIF(CHILDREN(), "Blocked") > 0, "Blocked", IF(COUNTIF(CHILDREN(), "On Hold") > 0, "On Hold", IF(COUNTIF(CHILDREN(), "In Progress") > 0, "In Progress", IF(COUNTIF(CHILDREN(), "Complete") > 0, "In Progress", "Not Started")))))

Thank you,

Caroline

Paul Newcome

I would just click there on row two and indent it once so that it is a child of row 1.

Paul Newcome

Are you able to show that status column along side the same group of rows in the Primary Column so we can see the indentations?

delaurellc

here you go

Paul Newcome

It looks like it is working in this most recent screenshot. What about a screenshot of the sheet where it is not working?

delaurellc

now it seems to be working in all sheets, what would cause this? UGH!

This code has been here for weeks and all of a suddent it was setting everything to complete? Now all of a sudden it has fixed itself.

delaurellc

found one

Paul Newcome

It looks like the second row is not indented to be a child of the first row. This means that

COUNT(CHILDREN())

is generating zero and

COUNTIF(CHILDREN(), "Complete") is also generating zero.

Since zero equals zero, your first IF is technically true which is outputting the "Complete".

delaurellc

So that should be the last item on the list?

Paul Newcome

I would just click there on row two and indent it once so that it is a child of row 1.