Welcome!

Sum Children If other cells are Checked

Hello Community,

I'm trying to get a sum of children cells if a checkbox in another column is checked.

For instance, if Column A has row 1 checked, I want the Column 10 row 1 counted as part of the sum.

Formulas

Government

Support

Hi Craig,

Try this.

Formula: =SUMIF(CHILDREN(If@row); 1; CHILDREN([Total Test]@row))

Please see the attached link/screenshot for more information.

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Andree,

Thank you so much. This worked wonderfully!

This is the formula that worked for me.

=SUMIF(CHILDREN(If@row), 1, CHILDREN([total test]@row))

Great!

Happy to help!

Complete % calculation issue
I’m having an issue with the % Complete roll-up in Smartsheet. In the File Storage parent row (line 10), two out of the three child tasks are marked 100% complete, but the parent row is still showing inaccurate % instead of calculating the summary correctly. Could you help check why the parent row is not calculating…
Formula returning "2" suddenly, other cells, same formula not returning the "2"
Please see attached, formula has worked for a long time an typically pulls the data from another sheet as intended. I looked today and suddenly I have a "2" in a lot of the empty fields, and cannot figure out why. The formula I am using: =IFERROR(IFERROR(INDEX({PERFECTION YARD CHECK RO #}, MATCH(VIN@row , {PERFECTION YARD…
Formulas reading from ROW above.
Hello Community, Especially you @Paul Newcome the Formula Guru! I cant resolve this problem in the last 2 columns of this sheet. As you can see the Expected Cumulative Progress % is adding the Progress Weight + the value of itself from the row above…. any idea how to make this dynamic? Whenever new row is added / removed…