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 .
Want to try it in your site? InstallSimple Tables for Confluence from the Atlassian Marketplace.