Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

sum children

Michael Pierson
edited 12/09/19 in Archived 2015 Posts

I can not get two parent rows in a column to sum or count as a total. I only get "0".


I have parent row#1 that counts 4 children with ="Files: " + COUNT(CHILDREN()) and I have parent row#2 that counts 3 children with ="Files: " + COUNT(CHILDREN()) . However I am not able to total these two parents rows into a total number. Even though I put ="Total: " + SUM(CHILDREN(Name2, Name17)) , I continue to get answer of "0"

Any help would be appreciated




  • Travis
    Travis Employee

    Hi Michael, you are getting a 0 because you are trying to sum the child rows which likely contain text values and not numbers (you cannot sum text). Try using this formula:



    ="Total: " + COUNT(CHILDREN(Name2, Name17))

  • Michael Pierson



    That worked perfect. Thanks so much!



  • Lisa Hallowell
    edited 05/06/16

    I am trying to add 3 cells in a child row ... the cells contain links to other sheets ... any suggestions - tried this formula ="Total: " + SUM(CHILDREN(Name2, Name17)

  • Travis
    Travis Employee

    Hi Lisa, 


    If your intention is to sum the children of a particular parent row, then you need to reference only that parent row. 


    If your parent row is row 2 and you want to sum the children in the Name column, try this:


    ="Total: " + SUM(CHILDREN(Name2)

  • Billy Fadli
    Billy Fadli ✭✭
    edited 01/16/17

    Hi All,


    Here is my case.. The column : Name | Prices

    i've 1 parent and 3 children
    Parent for ex : row 2

    Children = Row 3-5


    Could i get the total price in the row parent? I try =SUM(CHILDREN([Name]2)) and i got 0, 

This discussion has been closed.