Rollup and mirror columns
How to use Rollup and Mirror columns to bring in and total data from other linked boards.
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
- A Connect boards column must already exist on the board (it defines which items are linked).
- Know which column on the target board you want to reflect or summarize.
Create a mirror column
- Open Projects and enter the board.
- Click the + at the end of the columns and choose Add column.
- Search for and pick Mirror.
- In the config panel, choose the Connect column to follow and the target column you want to reflect.
- Save. Every row now shows, live, that column's value on the linked items.
Create a rollup column
- Click + → Add column → Rollup.
- Choose the Connect column and the target column to roll up.
- 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).
- Optional: set a unit, its position (prefix/suffix) and decimals to format the result.
- 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
Related articles
-
Organize work with Projects & boards
Create boards with groups, tasks and subitems, use columns and Kanban or List views, link tasks to deals and contacts, and automate with recipes.
-
Projects (boards): complete guide
Projects in depth, in 54 chapters: boards, columns, formulas, Kanban, Calendar, Gantt and Workload views, forms, automations, My tasks and dashboard.
-
Column types in boards
Status, date, person, number, formula and more: build boards that fit your process.
-
Kanban and List views
See the same board as draggable columns or as an ordered list, depending on what you need.
-
Recipes (automations) inside boards
Create "when this happens, do that" rules so your board works on its own.