Welcome!

Summing up child row cells to parent rows

I have reported production numbers and I have shipments going out. I want to take the production number and subtract it from the shipped # and give me a remaining QTY. When logistics moves more of the product they will add a row for the second shipment and make it the child to the first shipment. I would like the qty from the second shipment to be subtracted from the remaining qty in the first. Here is the formula i have so far and I'm getting an error.

=SUM([Packed Out Retail Cases]3 - [Quantity Shipped 1]3)(SUMIF(CHILDREN([Quantity Shipped 1]4-[Remaining QTY]3)))

Any help would be greatly appreciated.

Thanks

Find more posts tagged with

Comments

Andrée Starå

Hi Douglas,

Can you describe your process in more detail and maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Andrée Starå

Wouldn't it just work if we SUM the children for each column in the parent row and get the total remaining sum?

Sign in to join the conversation!

Quick Links

Trending discussions

Sheet Button on Left of Sheet - Error Message
Could somone tell me what button this error message is referring to? I have an Enterprise plan and do not see anything like a "Sheet" button.
Access to a longer published sheet
Hi! I created a Calander events availability tracker and I attached it to a dashboard that I am creating in Smartsheet. It is now unable to display and a notification appears saying that, "The sheet you are attempting to access is no longer published. Please contact the Smartsheet document owner." I am wondering how to…
authenticator help
I tried to sign into my Smartsheet portal it asked for an authenticator code. I don’t have one and I can’t find the QR code to authenticator to my own Microsoft authenticator app. Can anyone help me?