Parent Row Roll Up
I am looking to create a formula that will do the following:
If all child statuses = Complete, it will say "Complete"
If at least one child says in progress or complete, the parent row will say "In Progress"
If all child statuses say Not Started, or are Blank, it will say "Not Started"
I tried using this as a shell:
=IF(COUNTIF(CHILDREN(), "Not Started") > 0, "Not Started", IF(COUNTIF(CHILDREN(), "In Progress") > 0, "In Progress", IF(COUNTIF(CHILDREN(), "Complete") > 0, "Complete", "Verify")))
But it is making the whole row say Complete is only one if complete.
Anyone have any ideas?