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

Tags:
· Share on FacebookShare on Twitter

Comments

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

    Jordan,

     

    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.

     

    Craig

     

     

     

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories