Count of Children Code not working on top row of schedule


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,


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!