Complete/Not Complete Dots Formula for multiple rows

06/30/20
Answered - Pending Review

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 NewcomePaul Newcome ✭✭✭✭✭

    Are the below rows indented as "child rows"?

    thinkspi.com

  • yes

  • Paul NewcomePaul 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

Sign In or Register to comment.