Connect columns (relationships between boards)
Link items from one board to another and pull values in with rollup and mirror columns.
Watch this step in the video · Connect boards
What a connect column is
A Connect boards column (🔗) links an item on this board to one or more items on another board. For example, connecting each Task to its Project, or each Order to its Customer. Once items are connected, you can pull data from the linked board without copying it by hand, using two computed columns:
- Rollup (
Σ): aggregates values from the linked items (sum, average, count…). - Mirror (
⇄): shows a column from the linked item as-is.
This avoids duplicating information and keeps everything in sync across boards.
Before you start
- You need two boards in the same workspace: the current one and the target.
- For rollup and mirror, the board must already have a Connect boards column.
1) Create the connect column
- On the board, click + ("Add column") and choose Connect boards (
🔗). - Connect boards opens. Under Target board, pick the board you want to relate to ("Choose a board…").
- Turn Allow multiple items on or off depending on whether each row can link one or many items from the other board.
- Click Save.
- In each cell of that column, click to search and select the item(s) from the target board.
2) Pull a value in with Mirror
- Add a Mirror column (
⇄). - Under Connect column, choose the connect column you created earlier.
- Under Column to mirror, pick which target-board column to display.
- Save. The column shows that value from the linked item (read-only).
3) Add a total with Rollup
- Add a Rollup column (
Σ). - Choose the Connect column and the Column to roll up from the target board.
- Choose the Function: sum, average, min, max, count, etc.
- (Optional) Set the unit, the unit position (prefix
$100or suffix100 hrs) and decimals. - Save.
Verify it worked
- In the connect column, cells show the linked items as chips.
- The mirror and rollup columns fill themselves in based on the links.
- If you change a value on the target board, the mirror and rollup update.
If it doesn't work
- "First add a Connect boards column to this board": rollup/mirror needs an existing connection. Create the Connect boards column first.
- The target board doesn't appear: it must be in the same workspace and your role must have access to it.
- The rollup gives a strange value: check that the Column to roll up is numeric and the Function is the right one (don't sum text).
- I can't type in a mirror/rollup cell: they're read-only; edit the value on the source board.
Tips
- Always start with the Connect boards column; rollup and mirror depend on it.
- A single connect column can feed several mirror and rollup columns: connect once, reuse many times.
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.