By adding markdown to a formula column, you can call attention to critical information, color-code data fields, or add other visual customization to a structure:
Specify the text formatting
Add text and background color
Insert emojis
...
Using Markdown
To add markdown to a formula column:
...
| Note |
|---|
Your formatting will not display correctly unless the Markdown option is selected. |
| Anchor | ||||
|---|---|---|---|---|
|
The following sections explain how to add text formatting, color, and emojis to a formula column.
Text Formatting
The following markdown can be used for text formatting.
Text Formatting | Format | Example | Result |
|---|---|---|---|
Italics | *Text* | "My Favoirte book is *The Lord of the Rings*" | My favorite book is The Lord of the Rings |
Bold | **Text** | "**STOP!**" | STOP! |
Heading 1 | # Text | "# Section One" |   |
Heading 2 | ###### Heading 2 Text | "###### Sub-section Two" |   |
Code Snippet | ` Code Snippet ` Note: These are backticks, not apostrophes. | "`<var_name> = <value>`" |
|
Text and Background Color
The following markdown can be used to specify background and text colors.
Formatting | Format (using name) | Alternative Format (using hex value) | Result |
|---|---|---|---|
Text Color | :panel[text]{color=red} | :panel[text]{color=#FF0000} | text |
Background Color | :panel[text]{backgroundColor=green} | :panel[text]{backgroundColor=#008000} |  |
Text and Background Color | :panel[text]{color=white backgroundColor=green} | :panel[text]{color=#FFFFFF backgroundColor=#008000} |  |
Emojis
A variety of emojis are available, including smiley faces, symbols, flags, and more. Emojis can be added using the following format: :Emoji_Name:
Emoji | Format | Example | Result |
|---|---|---|---|
Smile Face | :smile: | "Great Job :smile:" |  |
Smiley Cat | :smiley_cat: | ":smiley_cat: Purr!" |   |
Flag | :triangle_flag_on_post: | ":triangular_flag_on_post: IMPORTANT" |   |
For a complete list of available emojis, see https://github.com/ikatyang/emoji-cheat-sheet/blob/master/README.md
| Note |
|---|
Some emojis may not work with all operating system and browser combinations. |
Using Variables and Expressions
You can also create conditional formatting using variables and expressions by including markdown in a Text Snippet. In the following example, we've color-coded the assignee name based on their team.
...
| Tip |
|---|
Text snippets are enclosed on both sides by three double quotes ("""). |
Hyperlinks
Hyperlinks are supported for items within the current Jira / Confluence instance only.
For security purposes, hyperlinks are not supported for locations outside the parent Jira or Confluence.
Examples
Example 1: Progress Warnings
In the following example, we created a simple formula to draw attention to items that are overdue or nearing their due dates:
...
To learn more about using If statements, DAYS_BETWEEN, or any other functions, see Expr Function Reference.
Example 2: Project Markers
In this example, we've created a color-coded column to quickly identify each project we're working on.
...
| Code Block |
|---|
CASE(project, "SAFe Program", ":red_circle:", "SAFe Team A", ":purple_circle:", "SAFe Team B", ":green_circle:", "Marketing", ":large_blue_circle:") |
Example 3 - Issue Health
The example we used at the top of this article helps users visualize the health of each issue by calculating the amount of time until its due date and comparing that with the remaining estimate:
...