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.

How do you SUM a Child row with the condition that a separate colunm check box is ticked

Jordan Gouwop
edited 12/09/19 in Archived 2015 Posts

Hi I want my spreadsheet to SUM the child numerical value under the condition that the tickbox in a separate column is ticked, so far I have come up with the formula ="Total Withdrawn: " + SUMIF(Completed:Completed , CHILDREN()) but it doesnt seem to work. Some help plese.



  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 12/20/15



    You are close,

    You need the row # for the parent row.


    Something like this should work:


    =SUMIF(CHILDREN(Completed23), 1, CHILDREN(ValueColumn23))


    for row 23 as the parent.

    The ValueColumn is the column containing the numbers to be summed.


    Hope this helps.






This discussion has been closed.