View Source

Customize your structure, call attention to critical information or color-code data fields using wiki markup within formula columns.

Wiki markup allows you to:

Specify the text color within a column
Highlight cells with background coloring
Insert images
Add emojis

Using Wiki Markup

To add wiki markup to a formula column:

Click the Add Column button (+) and select Formula

Enter a column name.
Include wiki markup language in your formula column, surrounded by double quotes ("). See Markup Options below for more details.
Under the Format menu, select Wiki Markup. (This is important - your content will not display correctly unless the Wiki Markup format is selected.)

Structure for Jira - Version 5.2 > Wiki Markup in Formula Columns > Wiki Markup Formula - Color Panel.png

As you save/update the formula, your new column should update automatically. Once you're finished, click anywhere on your structure to close the Add Column dialogue and see your new column.

The example above highlights all the Epics in the structure:

Structure for Jira - Version 5.2 > Wiki Markup in Formula Columns > Epic Markup.png

Here's the formula we used - just in case you want to try it yourself: If (issuetype="Epic"; "{panel:bgColor=#ADFF2F}Epic{panel}")

With a few more If statements, you could color-code your entire structure by issue type. Or you could assign different colors to each Assignee or some other custom field. The possibilities are endless!

Markup Options

Structure uses the Jira Markup language to enable wiki markup within formula columns.

Using wiki markup, you can add the following elements to a cell:

Custom text formatting
Text, background and border color
Images
Emojis

You can find a complete list of available formatting options and conventions on Jira's Text Formatting Notation Help page.

All markup language should be included between double quotes (").

While it is possible to add tables and lists to a formula column, we do not recommend it. Due to the limited space, these items may not appear as expected.

Export

Wiki Markup can be exported to Excel or printed, using Structure's Export feature.

Your markup should export just as it appears in Structure, with some exceptions:

Colored borders are not exported to Excel or printable.
When exporting to Excel, text cannot be combined with emojis or other images within the same cell. If both are present, only the text will be exported.

It's fine to mix text and emojis/images in the same column, just not the same cell.

Examples

Example 1: Progress Warnings

In the following example, we have created a simple formula to draw attention to overdue and upcoming due dates:

When an issue is overdue, a red "OVERDUE” warning appears in the column
When an issue is due within the next 7 days, the columns displays a green “Due Soon”
When there's over a week to go, the issue gets a smiley face
And if the issue doesn't have a due date, it let's you know that too

Structure for Jira - Version 5.2 > Wiki Markup in Formula Columns > Wiki Markup - Due Date Warning.png

To accomplish this, we added markup language to a standard If statement:

if (DueDate < today(); "{color:red}OVERDUE{color}"; DAYS_BETWEEN(today(), DueDate) <=7; "{color:green}Due Soon{color}"; DAYS_BETWEEN(today(), DueDate) >7; ":D"; "{color:blue}Needs Due Date{color}")

Structure for Jira - Version 5.2 > Wiki Markup in Formula Columns > Wiki Markup Formula - Due Date Warning.png

We used text to call attention to overdue items, but you could also add a flag: "(flag)"

To learn more about using If statements, DAY_BETWEEN, or any other functions, see Expr Function Reference.

Example 2: Project Markers

In this example, we've created a column to quickly identify each project we're working on. In this case, each project is marked by a unique star color.

Structure for Jira - Version 5.2 > Wiki Markup in Formula Columns > Wiki Markup - Project Stars.png

To create this column, we used the special character notations for stars "(*)" - along with color designations:

If (Project = "SAFe Program"; "(*b)"; Project = "SAFe Team A"; "(*y)"; Project = "SAFe Team B"; "(*r)"; Project = "Marketing"; "(*g)")

You could apply this same concept to any field, and you don't have to stick with stars. For example, you may want to color-code issues by team – or insert photos of your team mascots!