How to count grandchildren.

AARTEAGA
AARTEAGA
edited 12/09/19 in Smartsheet Basics

I'm trying to count how many grandchildren I have in a chart, how do I create the formulas for this?

Note that I would be adding and removing rows and I need this counter to keep updating with rows inserted and removed.

Example:

  • Parent (Grandchildren Count of 6)
    • Children (3)
      • Grandchildren
      • Grandchildren
      • Grandchildren
    • Children (2)
      • Grandchildren
      • Grandchildren
    • Children (1)
      • Grandchildren

Grandchildren.PNG

Comments