The display format feature allows you to select between some numeric and duration formatting styles for a higher customization of your displayed value.
The specified format will be used to display or present the result of your calculation. Internally the field value is always stored as a number, even for durations, where the number will be later interpreted as a number of milliseconds.
Currently, display formats can only be set for Custom number formula and Templates returning a number.
When no option is selected, the default format is automatically set to unformatted.
Update/set via the field overview page
The most common way to update/set a display format is by accessing the configuration of the field you want to update via the field overview page. Also see Manage existing formula fields / Field overview.
-
Click the formula field name of the field you want to update
-
Scroll down to the bottom of the configuration menu until reaching the section with the display formats
-
Choose to display the result as a number (with various additional formatting options) or a duration (e.g. time since creation = 2w 3d)
-
Choose a predefined number format or use a custom pattern to e.g. add a suffix (miles, kg…🔥)
-
Save the configuration
Display as (Number, Duration or Progress bar)
You can choose whether you want to display the returned value as a number, in a predefined duration format or visualise it as a progress bar. Each selected option will then let you choose an additional formatting style (the way the value is finally displayed in a work item).
Formatting styles
🔢 Number
If your formula field is being used to store a simple number (e.g. a dollar quantity), you have the following formatting options. Choose a valid format and freely use additional characters to indicate the entities (e.g. currencies, weights etc.)
You can even use emojis like 💵 💶 ⭐️ when selecting a custom format!
|
Formatting style |
Example field value |
Displayed value |
Description |
|---|---|---|---|
|
Default (unformatted) |
123456.789 |
123456.789 |
The value will be returned as stored. |
|
Custom format |
|
|
Be creative and combine a number format with suffixes or prefixes. |
|
|
123456.789 |
123,456.789 |
Each pound sign (#) denotes a digit, the comma is a placeholder for the thousands separator, and the period is a placeholder for the decimal separator. |
|
|
123456.789 |
123456.79 |
The value has three digits to the right of the decimal point, but the pattern has only two. The last digit will be rounded up. |
|
|
123.78 |
000123.780 |
The pattern specifies leading and trailing zeros, because the 0 character is used instead of the pound sign (#). |
|
|
12345.67 |
$12,345.67 |
The dollar sign $ will be shown as a prefix. |
|
|
12345.67 |
12,345.67 EUR |
The currency symbol EUR will be shown as a suffix. |
Custom pattern
Upon selecting “Custom format” you have the option to create your own pattern following the same principles as in the above options.
|
Custom pattern examples |
Input |
Output |
Tips |
|---|---|---|---|
|
|
99.9 |
99.9 % |
Periods “.” can be used to separate units from decimal numbers. |
|
|
123456.78 |
12,34,56.8 |
Commas “,” can be used to form patterns to improve readability by separating hundreds from thousands or in any other position before the period. |
|
|
5 |
⭐️5⭐️ |
Emoji-friendly prefixes and suffixes can be added after the numeric pattern has been formed. |
|
|
6579.867 |
6579.87🔥 |
Hashes “#” serve merely as placeholders for numbers before the period. After the period they will represent the maximum number of decimals that can be displayed before rounding the next decimal number. |
|
|
11,2 |
011.200 |
Zeroes “0” serve the same functions as hashes, but they also append and suffix the number with zeros according to the number of zeroes that the pattern contains if the original value is not large enough or if it does not contain enough decimal numbers. |
⏲️ Duration
If your formula field is being used to store a duration (e.g. days/hours between the current date-time and the due date), you will have the following formatting styles available:
Duration display format
Make sure to enter a number that represents a quantity of milliseconds. Otherwise, an incorrect duration will be shown after the conversion. When working with Jira date fields (e.g. difference of current date and due date, the result will automatically be returned in the correct format).
The conversion can be previewed in the Preview area during the formula number field configuration.
|
Formatting style |
Example field value |
Displayed value |
|---|---|---|
|
Short |
3600000000 |
|
|
Long |
3600000000 |
|
For either style, you can switch whether the duration formatting uses the 24/7 systems or the global Jira time tracking settings. E.g. if the global time tracking settings define a 5-day-8-hour workweek, 17h 30m will be displayed as “2d, 1h, 30m”.
📊 Progress bar
If your formula field is used to store a progress towards some maximum value, e.g. a fulfillment percentage or a rating, you can configure the maximum range of your progress bar. Simply enter the number that represents a full bar for your field (e.g. 100 for a percentage, or 5 for a rating).
The field value will then be displayed next to the progress bar as “<Field value> / <Max Range>”
The default setting for Max Range is 100.