Skip to content

Row Formulas

A Row Formula column lets the people who edit a table write their own formula in each cell, like in a spreadsheet. A formula can use the other cells of the same row — for example [Qty] * [Unit price] — and the cell shows the result. Each row can have a different formula, a plain number, or nothing at all.

Writing a formula

  1. Open the table and click Edit.
  2. Click a cell in the Row Formula column. The cell switches from the result to the formula (shown in a monospace font).
  3. Type a formula. Refer to another column by its name in square brackets — [Unit price] — or click a cell in the same row to insert its name at the cursor.
  4. Press Enter or click elsewhere to see the result. Press Esc to undo your changes to the cell.
  5. Click ✓ Save to save the table.
Connected Table⋯
Quote — line items ✓ Save✕ Cancel
ABCDescription #Qty 123Unit price 123Discount % Net amount
Onboarding workshop21,200.00102,160.00
Data migration 1 3,500.00+ 15 [Qty] * [Unit price] * (1 - [Discount %] / 100)
Premium support (12 mo)1290.001,080.00
Travel (flat fee)500.00
Total6,715.00
Editing a Row Formula cell: the formula is shown in place of the result, and the other cells of the same row are outlined — click one to insert its column name at the cursor. Each row can have its own formula, or a plain value.

While you edit a formula, the other cells of that row are outlined: clicking one inserts its column name instead of moving the cursor into it. Cells of other rows can’t be referenced — a Row Formula only ever sees its own row.

In edit mode, hover a Row Formula cell to see its formula as a tooltip.

Formula syntax

Values

You writeMeaning
[Column name]The value of that column in the same row
12, 0.5, -3Numbers (use a dot for decimals)
"Over budget" or 'Over budget'Text
true, falseYes / no
( … )Grouping

Any column can be referenced. Number, integer, sequence and formula columns give numbers, checkboxes give yes / no, and text, date and single-select columns give their text (so [Status] = "Approved" works).

Operators

OperatorMeaningExample
+ - * /Add, subtract, multiply, divide[Qty] * [Unit price]
%Remainder[Qty] % 12
= or ==Equal to[Status] = "Approved"
<> or !=Not equal to[Status] <> "Rejected"
< <= > >=Comparisons[Spent] > [Budget]
&&And[Approved] && [Qty] > 0
||Or[Urgent] || [Priority] = "High"
!Not![Approved]

Functions

FunctionResultExample
SUM(a, b, …)Sum of the valuesSUM([Q1], [Q2], [Q3], [Q4])
AVG(a, b, …)Average of the valuesAVG([Score 1], [Score 2])
MIN(a, b, …)Smallest valueMIN([Quoted], [Budget])
MAX(a, b, …)Largest valueMAX([Actual], 0)
ROUND(value, places)Rounded to places decimals (0 if omitted); halves round away from zeroROUND([Hours] * 1.15, 1)
IF(condition, then, else)then if the condition is true, otherwise else (blank if else is omitted)IF([Approved], [Total], 0)

Functions can be nested: IF([Qty] > 100, ROUND([Total] * 0.95, 2), [Total]).

Examples

GoalFormula
Line total[Qty] * [Unit price]
Net after a discount[Qty] * [Unit price] * (1 - [Discount %] / 100)
Total including 20% tax, roundedROUND([Net] * 1.2, 2)
Budget used, in percent[Spent] / [Budget] * 100
Flag overspendingIF([Spent] > [Budget], "Over budget", "OK")
Count only approved linesIF([Approved], [Amount], 0)
Best of three quotesMIN([Quote A], [Quote B], [Quote C])
A one-off value500

Results

  • Numbers are rounded to the column’s decimal places (2 unless the administrator set another number).
  • Yes / no results show as TRUE or FALSE.
  • Text results are shown as they are.
  • An empty formula gives an empty cell.

Blank cells

  • If every cell the formula uses is blank, the result is blank — so a new, empty row doesn’t fill up with zeros.
  • Otherwise blank cells count as 0 in arithmetic ([Qty] * [Price] with no price gives 0), and SUM, AVG, MIN and MAX skip them: the average of 4, a blank cell and 8 is 6.

Errors

When a formula can’t produce a result, the cell shows an error in red instead. Hover an #ERROR cell to see the details.

ErrorMeaningHow to fix it
#REF!The formula uses a column that doesn’t exist — a typo in a name, or a column that was deleted.Correct the name, or click the cell to insert it.
#CYCLE!The formula depends on itself, directly or through another formula column (A uses B, B uses A).Remove one of the references.
#ERRORThe formula couldn’t be calculated: a typo in the syntax, division by zero, an unknown function, or a formula that takes too long.Check the formula against the syntax.
Connected Table⋯
Budget check
ABCItem 123Budget 123Spent Used % Check
Licences4,000.003,100.0077.50OK
Hardware2,500.002,900.00116.00Over budget
Training0.00450.00#ERROROver budget
Contractors6,000.001,200.00#REF!#REF!
Travel1,500.00300.00#CYCLE!#CYCLE!
Problems show as red error values instead of a result — hover an #ERROR cell to see the reason. An error in one formula carries over to formulas that use it.

If a formula uses another formula column that has an error, it shows the same error, so you can trace a problem back to where it starts.

How it works with other features

FeatureRow Formula columns
Totals rowNumeric results are included in the column’s summary (sum, average, min, max…); text and errors are skipped.
Required columnsNever required — a blank formula cell doesn’t block saving.
SearchSearches the results you see, not the formula text.
SortSorts by result, numerically.
Drag-to-fillCopies the formula down the column. Because references are to the same row, each row calculates with its own values — like a relative reference in a spreadsheet.
Merge cellsWorks as for other columns: the merged cell shows the first row’s formula and result.
Transposed layoutWorks the same way; the cells of the same row are in the same column.
ExportExcel, PDF, Word and CSV contain the results, not the formulas.
ImportRow Formula columns aren’t imported from files — enter formulas in the table.
Default valuesNot available for Row Formula columns.
Write APIAccepts formula text — see Cell values.

For administrators: adding a Row Formula column

  1. Open the field context’s column editor (Jira settings → Issues → Custom fields → your field → Configure → edit the context).
  2. Add a column and choose the type Row Formula.
  3. Optionally set Mantissa (decimal places) — the number of decimals for numeric results (default 2).
  4. Save the context.

Edit column

NameNet amount
TypeRow Formula

Type settings

Mantissa (decimal places)2

How row formula columns work

Each cell holds its own formula, written by whoever edits the table. A formula can use other cells in the same row: while editing, click a cell to insert it, or type its column name in square brackets.

[Quantity] * [Unit price]  ·  IF([Approved], [Total], 0)

Functions: SUM, AVG, MIN, MAX, ROUND, IF. Problems show as #ERROR, #REF! or #CYCLE!.

Adding a Row Formula column in the field context's column editor. The only setting is the number of decimal places for numeric results.

Row Formula columns can’t be marked required and have no default value. Everyone who can edit the table can write formulas in them — on the Apps panel, in the inline field editor, and on the customer portal.

Security

Formulas run in an isolated sandbox inside the browser. They can only read the values of their own row — not the page, the issue, other tables or the network — and a formula that runs too long is stopped and shows #ERROR. See How it works: data & security.