S
Simpleasyty
Help Center — Expression functions
INTRO
IntroductionInstall the appQuick startRuns on Atlassian
DATA PERSISTENCE
No data egressData residency
DATA SOURCES
Data sourcesImported dataSave as AttachmentConfluence ContentPage PropertiesNative Confluence tablesTable Excerpt / Include
DISPLAY
Display settingsSearchFiltersSortingGroupingRow numbersFull screen modeDownload tableConfidential labelRovo
COLUMNS
ReorderingRename headingHideIncognito modeText appearanceColumn colorsData typeGrouping aggregationFooter aggregationCalculated columnExpression functionsUse casesNested JSON fieldsDelete column
PIVOT TABLES
Overview
FORMATTING
Layout & spacingTable colorsTable heightPagination

Expression Functions

Use this page as a reference for writing expressions inside calculated columns.

Looking for practical examples first? Start with Calculated Columns .

Rules

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

Quick examples .

Aggregate + math

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

Date

=DAYS_TO(duedate)

String

=AFTER(email, "@")

Math + aggregate

=ABS(score - AVG(score))

Aggregate functions

SUM(expr)

Returns the total sum.

AVG(expr)

Returns the average value.

MIN(expr)

Returns the minimum value.

MAX(expr)

Returns the maximum value.

COUNT(expr)

Counts non-empty values.

COUNT_DISTINCT(expr)

Counts unique values.

Math functions

ROUND(value, decimals)

Rounds a number to a given number of decimals.

ABS(value)

Returns the absolute value.

FLOOR(value)

Rounds down to the nearest integer.

CEIL(value)

Rounds up to the nearest integer.

SQRT(value)

Returns the square root.

Date functions

TODAY()

Returns today's date.

DAY(date)

Returns the day of the month.

MONTH(date)

Returns the month number.

YEAR(date)

Returns the year.

QUARTER(date)

Returns the quarter label.

DAYS_TO(date)

Returns the number of days to a date.

String functions

LEFT(value, n)

Returns the first characters of a string.

RIGHT(value, n)

Returns the last characters of a string.

MID(value, start, length)

Returns a substring.

BEFORE(value, delimiter)

Returns everything before a delimiter.

AFTER(value, delimiter)

Returns everything after a delimiter.

Tips

  • Use short, readable expressions whenever possible.
  • Prefer practical formulas that your team can understand at a glance.
  • For real-world examples and suggested column names, see Calculated Columns .

Need a formula for your use case?

Can’t find the formula you need? Tell us what you are trying to calculate. We build new functions from real customer requests and will look at implementing yours.

Request a formula

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