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
- Open the table and click Edit.
- Click a cell in the Row Formula column. The cell switches from the result to the formula (shown in a monospace font).
- 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. - Press Enter or click elsewhere to see the result. Press Esc to undo your changes to the cell.
- Click ✓ Save to save the table.
| ABCDescription | #Qty | 123Unit price | 123Discount % | Net amount |
|---|---|---|---|---|
| Onboarding workshop | 2 | 1,200.00 | 10 | 2,160.00 |
| Data migration | 1 | 3,500.00+ | 15 | [Qty] * [Unit price] * (1 - [Discount %] / 100) |
| Premium support (12 mo) | 12 | 90.00 | 1,080.00 | |
| Travel (flat fee) | 500.00 | |||
| Total | 6,715.00 |
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 write | Meaning |
|---|---|
[Column name] | The value of that column in the same row |
12, 0.5, -3 | Numbers (use a dot for decimals) |
"Over budget" or 'Over budget' | Text |
true, false | Yes / 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
| Operator | Meaning | Example |
|---|---|---|
+ - * / | 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
| Function | Result | Example |
|---|---|---|
SUM(a, b, …) | Sum of the values | SUM([Q1], [Q2], [Q3], [Q4]) |
AVG(a, b, …) | Average of the values | AVG([Score 1], [Score 2]) |
MIN(a, b, …) | Smallest value | MIN([Quoted], [Budget]) |
MAX(a, b, …) | Largest value | MAX([Actual], 0) |
ROUND(value, places) | Rounded to places decimals (0 if omitted); halves round away from zero | ROUND([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
| Goal | Formula |
|---|---|
| Line total | [Qty] * [Unit price] |
| Net after a discount | [Qty] * [Unit price] * (1 - [Discount %] / 100) |
| Total including 20% tax, rounded | ROUND([Net] * 1.2, 2) |
| Budget used, in percent | [Spent] / [Budget] * 100 |
| Flag overspending | IF([Spent] > [Budget], "Over budget", "OK") |
| Count only approved lines | IF([Approved], [Amount], 0) |
| Best of three quotes | MIN([Quote A], [Quote B], [Quote C]) |
| A one-off value | 500 |
Results
- Numbers are rounded to the column’s decimal places (2 unless the administrator set another number).
- Yes / no results show as
TRUEorFALSE. - 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.
| Error | Meaning | How 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. |
#ERROR | The 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. |
| ABCItem | 123Budget | 123Spent | Used % | Check |
|---|---|---|---|---|
| Licences | 4,000.00 | 3,100.00 | 77.50 | OK |
| Hardware | 2,500.00 | 2,900.00 | 116.00 | Over budget |
| Training | 0.00 | 450.00 | #ERROR | Over budget |
| Contractors | 6,000.00 | 1,200.00 | #REF! | #REF! |
| Travel | 1,500.00 | 300.00 | #CYCLE! | #CYCLE! |
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
| Feature | Row Formula columns |
|---|---|
| Totals row | Numeric results are included in the column’s summary (sum, average, min, max…); text and errors are skipped. |
| Required columns | Never required — a blank formula cell doesn’t block saving. |
| Search | Searches the results you see, not the formula text. |
| Sort | Sorts by result, numerically. |
| Drag-to-fill | Copies 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 cells | Works as for other columns: the merged cell shows the first row’s formula and result. |
| Transposed layout | Works the same way; the cells of the same row are in the same column. |
| Export | Excel, PDF, Word and CSV contain the results, not the formulas. |
| Import | Row Formula columns aren’t imported from files — enter formulas in the table. |
| Default values | Not available for Row Formula columns. |
| Write API | Accepts formula text — see Cell values. |
For administrators: adding a Row Formula column
- Open the field context’s column editor (Jira settings → Issues → Custom fields → your field → Configure → edit the context).
- Add a column and choose the type Row Formula.
- Optionally set Mantissa (decimal places) — the number of decimals for numeric results (default 2).
- Save the context.
Edit column
Type settings
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!.
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.