Spreadsheet Organization

Landon Messal

Hello!

I am seeking advice on how best to sum child values by evaluating two columns. I'm also open to advice on how to best restructure my spreadsheet to accommodate what I'm looking for.

Here is a link to the test sheet I created.

https://app.smartsheet.com/sheets/788qPR5JXJM7vhM6M5hrM9GRvrrvfpvFvCJxwF51?view=grid

My questions are in the image below.

Andrée Starå

Hi @Landon Messal

I’d recommend adding a top level / top parent and then use sum children on each of the other levels/children.

Make sense?

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Landon Messal

@Andrée Starå , thanks for the quick response.

I'm not sure I understand.

Andrée Starå

@Landon Messal

Happy to help!

I'll show how in your sheet.

Landon Messal

Thanks @Andrée Starå !!