Premium Columns and Plan Requirements: Formula, Time, Auto-Number, Connect, Rollup and Mirror
Meet the six advanced Projects columns — Formula, Time, Auto-number, Connect boards, Rollup and Mirror — and what you need to use them.
Beyond the basic column types (Text, Status, Person, Date, etc.), Projects ships six advanced types, badged Premium in the column picker.
Requirements
- These columns are available within the plans that include Projects (Crece and up); check your current plan under Settings > Plan & Billing.
The six premium columns
- Formula: computes a value from other columns on the same item, including text or status columns (e.g.
{Price} * {Quantity}orIF({Status}="Done","✅","⏳")). Read-only — it recalculates on its own. - Time: a real start/stop timer per task, plus an optional manual base ("1h 30m"). The column footer sums the total.
- Auto-number: a read-only sequential number based on task creation order (add a prefix like "TASK-" and zero-padding).
- Connect boards: links an item to one or many items on another board (or the same one), within the same workspace.
- Rollup: on top of a Connect column, pulls and summarizes (sum, average, count, min, max, concat, etc.) a column's value across the linked items.
- Mirror: also on top of a Connect column, shows live (unsummarized) the value of a column from the linked items.
How to add one
- On the board, click Add column.
- Search for the type (premium ones carry the "Premium" badge).
- Configure its settings per type (for Rollup, pick the Connect column first, then the aggregation function).
Example
You create a Connect boards column on "Client projects" pointing at the "Clients" board. Then you add a Mirror column showing the linked client's email, and a Rollup column summing the budget of every project connected to that client.
Tips
- Set up the Connect boards column first — Rollup and Mirror both depend on it to know which items to look at.
- A Formula column can read a Rollup's result to run a further calculation.
Troubleshooting
- I don't see these types in the picker: confirm your plan includes Projects and that you have permission to edit that board's columns.
- Rollup or Mirror shows empty: check that the Connect column has at least one linked item, and that the chosen target column actually exists on the target board.
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.
-
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.
-
Tasks, subtasks and dependencies
Break work into steps and define what must finish before the next thing starts.