Parent Row Status Roll Up

roblutz

Hello!

I'm looking for help on a formula I have yet to find exactly what I am looking for. I have found a couple of others I have been tweaking, but not working exactly how I would like. I'm looking for a formula to roll up the status of children status to the parent row. Here is the breakdown:

If all statuses are Not Started - Roll up is "Not Started"

If any status is In Progress - Roll up is "In Progress"

If all statuses are Complete - Roll up is "Complete"

If any child is "N/A" - it is counted as "Complete"

Any help would be greatly appreciated!

Paul Newcome

Try this:

=IF(COUNTIFS(CHILDREN(), OR(@cell = "Complete", @cell = "N/A")) = COUNT(CHILDREN()), "Complete", IF(COUNTIFS(CHILDREN(), @cell = "Not Started") = COUNT(CHILDREN()), "Not Started", "In Progress"))

roblutz

Thank you that is PERFECT! :-)

Paul Newcome

Try this:

=IF(COUNTIFS(CHILDREN(), OR(@cell = "Complete", @cell = "N/A")) = COUNT(CHILDREN()), "Complete", IF(COUNTIFS(CHILDREN(), @cell = "Not Started") = COUNT(CHILDREN()), "Not Started", "In Progress"))

roblutz

Thank you that is PERFECT! :-)

Paul Newcome

Happy to help. 👍️