From your doc, it seems that you are using the subitems feature. Unfortunately, there is no straightforward solution to summarize data from the subitems. This is one of the features I requested in the subitems feedback.
However, I see two possible ways to handle this:
- The easiest way is to set up an automation that updates the parent rows every time a subitem changes in the table. The downside of this approach is that the automation doesn’t run immediately. In my experience, it can take up to one minute to actually execute and update the doc.
- You can add another column that calculates the sum of the subitems. In the leaf subitems, you would manually input data in an editable column, and the sum would be displayed in the parent subitems in a calculated column. The downside is that you will have two columns, which may not be visually appealing and could be confusing for users.
You can try using this trick to speed up automation, but you will still need to press a button manually.
I impleted both options on your doc. Let me know if some of them is suficient or you.
Best regards
Arnhold