Calculated Columns
Calculated columns let you create new values from existing fields using expressions.
COLUMNS
Choose the right tab first
Open Add columns in the table editor, then choose the Calculated columns tab to write a formula and define its visible heading.
Tab 1
Columns
Add the discovered source fields that the formula will reference, such as Budget, Quantity, or Due date.
Tab 2
Calculated columns
Write the formula, name the result, and review the detected data type before adding the new column.
How calculated columns work
Start with a simple expression such as =price * quantity, or combine multiple fields and functions. Each expression runs for every row and updates automatically when the data changes; the original source fields stay unchanged.
Start the expression with =, use column names directly, join text with &, and use ? : when you need conditional logic.
Create a calculated column
Open the calculation form, write a valid expression, then add it to the preview.
Open Add column
Edit the macro, switch to the Columns tab, and select Add column.
Choose Calculated columns
Select the Calculated columns tab in the panel that opens.
Enter the formula
In Formula, enter an expression beginning with =. It can reference only fields that have already been added to the table.
Name and add the result
Enter a Column header and optionally choose a Data type instead of auto-detect. When the formula is valid, select Add calculation. The preview updates immediately; save or publish the page when you are done.
What you can build
Start with a small formula that answers a useful question. These examples use the same fields and functions available in the editor.
| Formula | Use it for |
|---|---|
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 a meaningful metric. |
Status =DAYS_TO(duedate) < 0 ? "Overdue" : "On track" | Generate a dynamic label based on time. |
Days to due =DAYS_TO(duedate) | Track deadlines in real time. |
Email domain =AFTER(email, "@") | Extract a structured value from text. |
Initials =LEFT(firstname, 1) & LEFT(lastname, 1) | Generate a compact identifier. |
Year / Quarter =YEAR(orderdate) & " " & QUARTER(orderdate) | Build a reporting-ready time dimension. |
% of total =ROUND(amount / SUM(amount) * 100, 1) & "%" | Understand each row’s contribution to the total. |
Deviation =ABS(score - AVG(score)) | Measure the distance from the average. |
Edit an existing calculation
Open the calculated column from the Columns tab to change its formula, heading, type, or formatting. Formula suggestions and validation remain available while you edit.
Expression reference
Looking for available functions and syntax? See Expression Functions .
Turn a raw project list into a useful delivery view
A delivery team tracks owner, due date, effort, and completion in a shared Confluence table.
- Before
- The team can see the source values, but has to interpret progress and deadlines manually in every meeting.
- After
- They add Progress %, Days to due, and Status columns. The same source data now answers the questions the team asks every week.