Enhancement Request: BRANCH

Welcome to the New Smartsheet Online Community

You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

Enhancement Request: BRANCH


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