"Rollup" column type

AaronO

In planning budgets, I need to roll up costs into something like this:

I can put the formula sum(children()) into the rollup field, but I have to do it manually and I have to do it for all of the parent and grandparent fields. I can't make it a column formula because then I can't enter the values for the children.

It would be nice if there was a column type called "rollup" or something that accepted numbers in "leaf children" fields and automatically produced rollups for "parent" (and "grandparent" etc) fields.

There is precedent for this - it's how the "% Complete" fields work. This is exactly the same - simpler even, since it just need to sum the children.

thanks!

Aaron

AaronO

Another use for this kind of thing, inspired by this question:

All boxes are checked when converting "=IF(COUNTIF(CHILDREN(), 0) > 0, 0, 1)" to column formula

Athar

Oct 2, 2021

I have a project with parent and child rows with Check Box. I'm trying to use formula =IF(COUNTIF(CHILDREN(), 0) > 0, 0, 1) so that when children are checked parent row is checked.

This formula works fine in individual parent cell but when I convert it to column formula all check boxed are checked.

https://us.v-cdn.net/6031209/uploads/UWC0BFB1XMQ0/capture-1-png.png

https://us.v-cdn.net/6031209/uploads/TVEJB26Y37KL/capture-2-png.png

Please advice @Paul Newcome. Thank you.

---

View Post

This person wants a checkbox column that automatically checks a parent checkbox when all the children checkboxes are checked. A use for this is the "done" box in a card view - when all the subtasks are marked "done" have the parent task (optionally) automatically also be marked "done." I don't think there's a "rollup" mode for every column type, but for numbers and checkboxes...maybe others...it would be useful.

It can definitely be done using a separate helper column, of course.