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 https://monday.com/marketplace/10000124) 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.
A workaround I found is to add a Formula column, and to set the formula as a simple reference to the summary column. You can then display a total on the formula column. (And you can collapse or hide the actual summary column to keep things tidy.)
We developed an app called subitem automations that provides robust automation capabilities to subitems. Here’s an example of how it can be applied in this case →
You can find it in the monday.com marketplace in the platform or here - Subitem Automations - monday.com App Marketplace
Hope that helps!