Formula column where the wiki markup contains references to a field?

[PerÖ]

I'm trying to display the link to jira issues in a structure board where I want the background color of the link text to vary depending on whether a specific field in the jira issue has a certain value.

I'm trying something like this:

("key" in the local variables is intended to refer to the "Key" field holding the JIRA issue ID)

WITH redLink ="{panel:bgColor=#E65A5A}key{panel}"|"https://jira.something.com/browse/key":

WITH greenLink =

"{panel:bgColor=#ADFF2F}key{panel}"|"https://jira.something.com/browse/key":

if (MATCH(JIRA_COLUMN, "*SomeText*"); greenLink; redLink )

But the markup in the local variables is not picking up the "key" column...
It's probably something obvious that I do not see...

[PerÖ · Accepted solution]

Answering myself since I, typically, found the solution 15 minutes after posting this:

WITH redLink =CONCAT("{panel:bgColor=#E65A5A}", key, "{panel}"):

Simple enough!

[Nicholas Ellis _ALM Works_]

Hi Pero,

I see that you already figured out the answer for yourself.  I just wanted to explain why it works that way.

When we have a variable like key, Structure will try to define it. It will try to guess what it is based on its name.  Key matches the exact name of a jira field so it picks it up automatically.  But if I wanted to print out "key is KEY-123" I would do it like this:

CONCAT("key is ", key)

The concat function concatenates, or adds two strings together.  Here the first string is "key is " meaning this key is just treated as letters, because it is in a quoted string, while the second key is treated as a variable and pulls the key from the current issue into the formula.

I hope this helps.

Cheers,

Nick Ellis

[ALM Works]