How-to guide

How to Sum Subitems to the Parent Item in monday.com (2026)

Native subitem summaries show a total but can't feed automations or dashboards. Here's how to write a real SUM of subitem numbers into a parent column.

Updated Published

Direct answer: monday.com can display a subitem total on the parent natively. Right-click the subitem Numbers column header and choose “Show summary on parent item.” That’s enough for a visible total. But the summary is a mirror: automations, formula columns, exports, and most dashboard widgets can’t use it. To get a total that works everywhere, write a real SUM into a parent Numbers column with a rollup rule. Both methods below.

Can monday.com sum subitems natively?

For display, yes. The built-in option puts a summary of any subitem Numbers column on the parent row:

  1. Expand the subitems of any item so the subitem columns are visible.
  2. Right-click the subitem Numbers column header (say, “Cost”).
  3. Choose Show summary on parent item.

The parent now shows the total of its subitems’ values in that column, and it stays current as subitems change. If all you need is a number to glance at, stop here. It’s free and takes ten seconds.

That’s where it stops, though. The summary is a mirror-type value, not a real column, and that bites the moment the total needs to do something:

  • Automations can’t react to it — “when total cost exceeds budget, notify the PM” won’t fire off a mirror.
  • Formula columns can’t read it. monday.com formulas can’t read subitem values directly, and the summary doesn’t change that.
  • Exports and many dashboard widgets treat it as empty.
  • Integrations generally see nothing there either.

monday.com has been improving native rollup through 2026 (multi-level boards among other things), but as of mid-2026 the mirror limitation stands. The summary is display-only.

Why do people need the sum in a real column?

Almost every downstream feature in monday.com assumes real column values:

  • Automations: flag a project when subitem costs pass the budget, notify when estimated hours change.
  • Formula columns: margin = quoted price minus the rolled-up cost total.
  • Dashboards: a Numbers widget summing “Total cost” across parents works only if that column actually holds numbers.
  • Exports and integrations: Excel exports and API consumers read real columns. Mirrors come out blank.

The pattern across community threads is the same: the native summary gets people 80% of the way, then the mirror wall shows up.

How do you write a real SUM to the parent?

SubItems Pro writes subitem aggregates into ordinary parent columns:

  1. Add the Rollup Sync board view to your board and authorize it once (a standard monday.com OAuth prompt, one time per account).
  2. Create a rule: source = the subitem Numbers column (“Cost”), function = SUM, target = a Numbers column on the parent board (“Total cost”).
  3. Save with auto-sync on.

Webhooks now update the parent total whenever any subitem changes; Sync now recalculates on demand. Syncs are unlimited and never consume plan actions, and the free plan includes every function on one board with one rule, enough to verify it against your own data. Full setup detail is in the user guide.

Because “Total cost” is a normal Numbers column, everything works: sorting, filtering, charts, number-condition automations, exports.

What about averages, counts, and hours?

The same rule setup covers every numeric aggregate. Swap the function:

FunctionWhat it writes to the parentTypical use
SUMTotal of all subitem valuesBudgets, costs, effort estimates
AVGMean of the valuesAverage quote or score per parent
MIN / MAXSmallest / largest valueBest price received, worst-case estimate
COUNTHow many subitems have a value in that column”How many line items are priced yet?”
SUM_HOURS / AVG_HOURSHour columns as decimal hours (90 min → 1.5)Planned effort per parent

Rating columns take the same five functions as Numbers. For actual tracked time rather than planned hours, Time Tracking columns roll up with SUM_TRACKED / AVG_TRACKED, covered in rolling up subitem time tracking.

Common budget and cost setups

  • Line items → project total: subitems carry a Cost column and SUM writes “Total cost” on the parent. Trigger automations off it (“when Total cost changes, …” via a number-condition recipe) to catch budget overruns.
  • Billable-only totals: add a subitem filter to the rule so only subitems whose Status is “Billable” are summed, the standard fix for “my total includes internal tasks.” Filters are the one paid-gated capability (Basic plan and up). See filtered subitem rollups.
  • Total plus progress: pair the SUM rule with a done-counter so the parent shows both money and completion. The setup is in counting done subitems on the parent.

Start with the native summary. The day the total needs to feed an automation, a formula, a dashboard, or an export, switch to a rollup rule. Everything else that can roll up to parents is in the complete subitem rollup guide.

Frequently asked questions

Can monday.com sum subitem numbers to the parent item without an app?

Yes, for display. Right-click the subitem Numbers column header and choose 'Show summary on parent item'. The parent then shows the total of its subitems. It's a mirror-type value, though, so automations, formula columns, exports, and most dashboard widgets can't use it.

How do I get a subitem total into a real parent column?

Use a rollup app that writes actual values. In SubItems Pro, create a Rollup Sync rule: source = the subitem Numbers column, function = SUM, target = a Numbers column on the parent. Webhooks keep the total updated automatically whenever a subitem changes.

Can I sum only some subitems, like billable line items?

Yes — add a subitem filter to the rule (a Status column plus the labels that should count, e.g. only 'Billable'). Only matching subitems are summed. Filters are available on any paid SubItems Pro plan.

Can I average, count, or take the min/max of subitems instead of summing?

Yes. Numbers (and Rating) columns support SUM, AVG, MIN, MAX, and COUNT, all writing to a parent Numbers column. The setup is identical. Just pick a different function.

Do Hour and Time Tracking columns roll up too?

Yes. Hour columns use SUM_HOURS or AVG_HOURS and Time Tracking columns use SUM_TRACKED or AVG_TRACKED, all writing decimal hours (90 minutes becomes 1.5) into a parent Numbers column. Time tracking counts completed sessions only.

Why can't a formula column total my subitems?

monday.com formula columns only operate on the item's own columns and cannot read subitem values directly. The standard workaround is writing the subitem aggregate into a real parent column, which formulas can then read like any other column.