Rollup and mirror columns

How to use Rollup and Mirror columns to bring in and total data from other linked boards.

Jun 26, 2026

Watch this step in the video · Rollup and mirror

What rollup and mirror columns are

Rollup and Mirror columns pull information from another board into the one you are looking at, by following a Connect boards column. Both are read-only (computed live, never typed by hand):

  • Mirror: shows, as-is, the value of a column on the linked items (one chip per linked item). Great for seeing, say, the parent project's Status or Owner without opening it.
  • Rollup: takes that same value across all linked items and aggregates it with a function (sum, average, count…). Great for totalling hours, amounts or tasks from child items.

Rule of thumb: a mirror shows the raw values; a rollup folds them into a single number.

Requirements

  1. A Connect boards column must already exist on the board (it defines which items are linked).
  2. Know which column on the target board you want to reflect or summarize.

Create a mirror column

  1. Open Projects and enter the board.
  2. Click the + at the end of the columns and choose Add column.
  3. Search for and pick Mirror.
  4. In the config panel, choose the Connect column to follow and the target column you want to reflect.
  5. Save. Every row now shows, live, that column's value on the linked items.

Create a rollup column

  1. Click + → Add column → Rollup.
  2. Choose the Connect column and the target column to roll up.
  3. Pick the function: sum, average, min, max, count, concat, earliest or latest. The list adapts to the target column's type (numbers allow sum/average; statuses and text, count or concat; dates, earliest/latest).
  4. Optional: set a unit, its position (prefix/suffix) and decimals to format the result.
  5. Save.

Verify it works

  • Each row should show the computed value. The column footer shows the aggregated group total.
  • Change a value on the target board: the mirror and the rollup should update on their own (they are live).

If it doesn't work

  • Empty cell: the row has no linked items in the Connect column, or the column was never configured (missing Connect or target column).
  • Doesn't update: confirm the Connect column actually points to the right board and the item is still linked.
  • Don't see these columns in the menu: rollup and mirror are Premium features; check your plan includes them.

Tips

  • A numeric rollup can then be referenced inside a Formula column on the same item to keep computing.
  • Combine mirror + rollup: use the mirror to audit where a number comes from, and the rollup for the total.

Related articles

Was this helpful?

Related articles

Message us on WhatsApp