Calculated Columns

Add columns that are computed from other fields. Use formulas for arithmetic, text concatenation, or expressions. Works in both Simple Table and Simple Table (Bodied) macros.

How to use

Open the Columns tab in the setup panel.
Click Add column and enter a formula. Examples:

```
firstName
```
Uses the value from the firstName column as-is.
```
=price * quantity
```
Multiplies price and quantity to compute totals.
```
="First name" + " " + "Last name"
```
Concatenates text to form a full name.

You can customize the column header and force the data type. The formula is shown in the Accessor section so you can review or edit it later.

Supported features

Reference any existing column
Combine multiple fields
Perform arithmetic operations
Use string templates
Detect or force column data type

Use case: Real-time revenue calculation

Revenue Ops

Shinkansen Systems — Business Intelligence

Context: Orders include Unit Price and Quantity; the team needs a live “Total”.

Solution: Add a calculated column with =UnitPrice * Quantity. Totals update automatically.

Impact: Up-to-date reports without spreadsheets; fewer errors and faster reviews.

Calculated columns are ideal for dashboards, mixing structured and derived fields, or cleaning data before sharing.

Back to Introduction

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