"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:

https://community.smartsheet.com/discussion/83679/all-boxes-are-checked-when-converting-if-countif-children-0-0-0-1-to-column-formula

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.