Complete/Not Complete Dots Formula for multiple rows

Emily Quick

I am wondering if there is a way to create a formula in a cell that will tell you if the following 10-30 cells say complete. For example, when working on a project if all of the tasks beneath are "Green" or marked as "Complete", is there a way to have the top cell also say "Complete" only if all of the tasks also are? Or, if one of them is still "In Progress", the top cell will say "Not Complete" or show a "Yellow" dot? And if they all say "Not Started" have the top cell also say "Not Started" or show a "Red" dot? Let me know if anyone has any insight on how to do this. Thanks in advance!

Paul Newcome

Are the below rows indented as "child rows"?

Emily Quick

yes

Paul Newcome

You can try something like this...

=IF(COUNTIFS(CHILDREN(), "Complete") = COUNT(CHILDREN()), "Complete", IF(COUNTIFS(CHILDREN(), "Not Started") = COUNT(CHILDREN()), "Not Started", "In Progress"))