Enhancement Request: BRANCH

J. Craig WilliamsJ. Craig Williams Top Contributor
edited 12/09/19 in Formulas and Functions
08/05/18 Edited 12/09/19


  • Hi Craig,

    It sounds like you're looking to reference all children and children's children all in one formula.

    As you may know, the best way to do this currently is to add SUM(CHILDREN()) or COUNT(CHILDREN()) in each parent row and then SUM or COUNT the CHILDREN in the parent-most row (Ancestor 0).

    I typically try to lock these sorts of parent rows to prevent people from editing them. That way I can chase down any admins that may have inadvertently broken my sheet.

  • J. Craig WilliamsJ. Craig Williams Top Contributor

    Yes, Shaine, I am.

    The use case where I ran into it was JOIN(COLLECT()), which quickly clutters up the Sheet with useless cells. At least for COUNT or SUM, each level has meaning and usefulness.



Sign In or Register to comment.