Sign in to join the conversation:
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.
Hi Craig,
Try this.
Formula: =SUMIF(CHILDREN(If@row); 1; CHILDREN([Total Test]@row))
Please see the attached link/screenshot for more information.
Sum children if checkbox is checked
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!
I am trying to get the passenger count per month per year, and I can't seem to get the formula correct. I need to add the number of passengers for each month per year. If anyone could assist me with this, I would greatly appreciate it. Thanks!
I need to edit a large sheet that has a lot of predecessors. I need to delete one row and move another. when I make the changes the predecessors for proceeding lines are not correctly displaying the dates correctly. Need help.
Hi all, I'm having some issues with an index-collect formula. I have (3) existing sheets that list a unique project name (text field), as well as a producer assigned to work that project. The producer column in all (3) sheets is set as a contact field. In a separate sheet, I'm trying to auto-populate the producer…
