Subitem Rollup Pro
Roll up subitem values into normal item columns you can automate — plus extra summaries beyond native rollups.
Why native rollups aren't enough
monday's native rollups create a special "Mirror/Rollup" column. While useful for viewing data, this column type cannot be used in many automations. You can't easily trigger actions based on its value or use it in standard conditions.
How Subitem Rollup Pro fixes this
Our app provides a custom automation template that takes subitem column values and writes the result into a normal item column (like a Number or Text column).
Because the result is in a standard column, you can use it in any automation, integration, or dashboard widget that expects standard data. Plus, we offer additional summary methods beyond the basics.
How it works
To enable rollups, you simply add our automation recipe to your board. This recipe acts as the trigger: whenever a subitem changes, it tells our app to recalculate and update the parent item, keeping your data always in sync.
Automation template
1 {subitem column}
The source subitem column to roll up (e.g. "Status" or "Numbers").
2 {parent column}
The target column in your parent item where the result will be saved.
3 {rollup type}
The predifined rollup type (e.g. Sum, Average) or saved custom rollup type to use. Custom rollup types are created in the Subitem Rollup Pro Board View.
Custom Board View
While the automation template handles standard rollups, the Board View allows you to create custom rollup types with advanced logic. Once saved, these custom types become available in your automation recipes.
Advanced Filtering
Create filtered rollups that only include specific subitems. For example, calculate a Sum of "Budget" only where "Status" is "Approved".
Status to Status Builder
Define comprehensive logic for status rollups. Map combinations of subitem statuses (e.g., "All Done", "Any Stuck") to a specific status on the parent item.
How to set up Subitem Rollup Pro
Prerequisites
- You have permissions to install apps in your monday.com account.
- Subitems are enabled on the target board.
- You have at least one suitable subitem column to roll up (e.g., a Number column).
Step 1 – Install the app
- Open the monday.com Apps Marketplace.
- Search for "Subitem Rollup Pro".
- Click Install and choose which workspaces to install to.
Step 2 – Connect the App
Before using the automation, you must connect the app to your board to grant the necessary permissions.
- Add the "Subitem Rollup Pro" Board View to your board.
- Follow the on-screen prompts to authorize the app.
- (Optional) You can remove the view later if you don't need custom configurations, but the connection step is required first.
Step 3 – Create a custom rollup (Optional)
Note: Skip this step if you only need standard rollups (like Sum, Average) on all subitems.
Use the Board View to configure advanced logic:
- Open the Subitem Rollup Pro Board View.
- Click "Create New Rollup".
- Set up your filters (e.g., "Only Status=Done") or status mapping.
- Save your configuration. It will now appear as a "Custom rollup type" in the automation.
Step 4 – Add the automation template
4.1 Find the template and click Use
Go to your board's Automations center, search for the app's template, and click "Use".
4.2 Configure the template
Fill in the sentence: "When {subitem column} changes, calculate subitem rollup for {parent column} using {rollup type} save result to parent.".
- Subitem Column: Select the source column in your subitems.
- Parent Column: Select the target column on your parent item.
- Rollup Type: Select a predifined rollup type (e.g. Sum) or one of your Custom saved rollup types.
4.3 Test the template
Return to your board, change a configured column value in a subitem, and watch the parent item update automatically!
Supported rollups
All rollups occur within a single board. Cross-board rollups are not supported.
| Source | Target | Predefined rollup types |
|---|---|---|
| Numbers | Numbers | sum average median min max count |
| Time Tracking | Numbers | sum average min max |
| Text | sum average min max | |
| Date | Date | earliest latest |
| Timeline | total | |
| Timeline | Timeline | show |
| Date | earliest latest | |
| Numbers | total | |
| People | People | list |
| Dropdown | list | |
| Numbers | count_all count_distinct | |
| Status | Numbers | percent_done count_not_done count_done count_total |
| Text | ratio_done label_histogram | |
| Status | all_done any_done custom |
Additional summaries beyond native rollups
- Weighted Averages: Calculate averages based on another column's weight.
- Concatenation: Join text values from subitems into a single summary string.
- Conditional Counts: Count subitems only if they match specific criteria (e.g., Status is "Done").
How to disable or uninstall
Disable the automation
Go to Board Automations, find the template, and toggle it OFF. This stops future rollups but keeps the app installed.
Uninstall the app
Go to Apps > Manage Apps and uninstall "Subitem Rollup Pro". Existing data in your columns remains safe.
Pricing
Basic
- Up to 3 boards
- Unlimited subitem rollups
- Advanced summary methods
Standard
- Up to 10 boards
- Unlimited subitem rollups
- Advanced summary methods
Pro
- Up to 25 boards
- Everything in Standard
- Priority Support
FAQ
Does this app store my board data outside monday.com?
No, the app operates within the monday.com environment. We process data transiently to perform the calculation and write it back to your board immediately.
Can I use the rolled-up values in other automations?
Yes! This is the main benefit. Since we write to normal item columns (like Numbers), you can use them in any standard monday automation.
Is cross-board rollup supported?
Currently, no. The app supports rolling up subitems to their parent items within the same board only.
What happens to my data if I uninstall the app?
Your data is safe. The values already written to your columns remain there. The app simply stops updating them.