Complete/Not Complete Dots Formula for multiple rows

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!

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Are the below rows indented as "child rows"?

    thinkspi.com

  • yes

  • Paul Newcome
    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"))

    thinkspi.com

Help Article Resources