Column Formula to Count Grandchildren and not Parents

BrianSergio

#1 - I need to count the grandchildren in a column an NOT the parents. I have a column with multiple children rows (Parents) that in turn have their own children (Grandchildren) and want to be able to provide a Count of all the grandchildren.

#2 - Same as above, but need to count the grandchildren in a column an NOT the parents for Checkboxes that are checked. I have a column with multiple children rows (Parents) that in turn have their own children (Grandchildren) and want to be able to provide a Count of all the grandchildren checkboxes that are checked.

jmyzk_cloudsmart_jp

Hi @BrianSergio

If you add a helper column that counts the children, then you can use the column's cell values equal to zero to count the number of grandchildren.

https://app.smartsheet.com/b/publish?EQBCT=b32604552de94f75923b028236b54c1e