How do I create a formula to SUM the Child column only if a tickbox in a separate column is ticked

Jordan Gouwop

Hi I need help with creating a formula to calculate the numerical values in the child coulmn but only if a tickbox is ticked. So far i have come up with  ="Total Withdrawn: £" + SUMIF(CHILDREN(Completed2:Completed4))   

 

Any help would be appreciated.

 

Jordan

J. Craig Williams

Jordan,

 

See my answer here:

 

https://community.smartsheet.com/discussion/how-do-you-sum-child-row-condition-separate-colunm-check-box-ticked

 

Craig