Looking for formula to count checked rows of children "completed 5 of 5"

cbredehoeft

Paul Newcome

You would use something along the lines of

="Completed " + COUNTIFS(CHILDREN(), @cell = 1, CHILDREN([Task Name]@row), @cell <> "") + " of " + COUNTIFS(CHILDREN([Task Name]@row), @cell <> "")

cbredehoeft

Hi Paul,

I tried this but it still does not work. See below where the rows are completed with their parent rows "completed 5 of 5 but the main parent row is not tallying those. I expanded the rows to see if that helps. thank you!

cbredehoeft

Paul Newcome

It looks like you have changed it from a [Done] checkbox type column to a [Status] text type column. The formula I wrote was designed for the screenshot in your original post.

To work in the most recent screenshot, it would need to be modified like so:

="Completed: " + COUNTIFS(CHILDREN(), @cell = "Complete", CHILDREN([Task Name]@row), @cell <> "") + " of " + COUNTIFS(CHILDREN([Task Name]@row), @cell <> "")

cbredehoeft

Hi Paul,

Sorry about the change in columns and the confusion! This formula still does not work though. Appreciate your time either way.

Paul Newcome

What do you mean when you say it doesn't work. Is it throwing an error or outputting something unexpected? Can you provide a screenshot with the new formula?