Calculated Columns .

Calculated columns let you create new values from existing fields using expressions.

In the table editor, enter a formula in the column accessor, define the column header, and your table updates instantly — no exports, no spreadsheets.

You can start with simple expressions like =price * quantity or build more advanced formulas combining multiple fields and functions.

Expressions are evaluated per row and update automatically when your data changes.

How to use

Open the Columns tab.
Click Add column.
Enter your formula in the first field, starting with =.
Define the column header.
Click Save.

Expression basics

Start formulas with =.
Use column names directly.
Use & for text concatenation.
Use ? : for conditional logic.

What you can build .

Full name

=firstname & " " & lastname

Combine multiple fields into a readable value.

Line total

=price * quantity

Calculate totals directly inside the table.

Progress %

=ROUND(completed / total * 100, 1) & "%"

Turn raw numbers into meaningful metrics.

Status

=DAYS_TO(duedate) < 0 ? "Overdue" : "On track"

Generate dynamic labels based on time.

Days to due

=DAYS_TO(duedate)

Track deadlines in real time.

Email domain

=AFTER(email, "@")

Extract structured values from text.

Initials

=LEFT(firstname, 1) & LEFT(lastname, 1)

Generate compact identifiers.

Year / Quarter

=YEAR(orderdate) & " " & QUARTER(orderdate)

Build reporting-ready time dimensions.

% of total

=ROUND(amount / SUM(amount) * 100, 1) & "%"

Understand contribution to totals.

Deviation

=ABS(score - AVG(score))

Measure deviation from average.

Expression reference

Looking for available functions and syntax? See Expression Functions .

Want to try it in your site? InstallSimple Tables for Confluence from the Atlassian Marketplace.