Sheet Summary Formula to Rollup Parent Statuses

SergeantPup

Hi,

I have a working formula in my sheet that works beautifully to rollup/count the status within the sheet:

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

I want this same thing in Sheet Summary for the parents of my Status column. How do I build the sheet summary formula to do this same function but just by doing it to the parent rows of my Status column?

prime_nathaniel

@SergeantPup

Add ancestory helper column so you can denote parents (if you dont have another existing flag for this). Now do your same countif approach filtered to parent rows only.

ex. if count of parent row statuses that are complete = total parent rows then everything is complete so summary = complete, etc , etc

SergeantPup

I DO have a parent helper column (Parent Column) already with a "Yes" where row is parent but I'm not following you on how to build the formula. How do I tell it to only count the rows if Parent Column = Yes and then count the Status of that row?