Is there a way we can generate the total of the cost column from the sub-items to the parent item without using the show summary on parent item and by using either formula or number instead?

Currently I am using the show summary on parent item but I cannot see the sum of the mirror column just how we see in the formula or number columns. Screenshot shared below. The actuals is the mirror column from the sub-items.


hi @ibakordor

Welcome to the community. As you noticed you can’t use the summary column in the parent to do calculations etc. The app Rollup Subitems (see solves that because the app doesn’t use the show summary in parent item. Instead it has a different approach and subitem columns will be rolled up to normal (e.g number) columns in the parent item.

With this, you can use the summary in the parent item in formulas and other automations.