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
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
Comments
-
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))
-
Travis,
That worked perfect. Thanks so much!
Mike
-
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)
-
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)
-
Hi All,
Here is my case.. The column : Name | Prices
i've 1 parent and 3 children
Parent for ex : row 2Children = Row 3-5
Could i get the total price in the row parent? I try =SUM(CHILDREN([Name]2)) and i got 0,
