Column Formula to Count Grandchildren and not Parents

Options

#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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!