Structure Formula - How to add color to a variable using IF conditions

[nbabin]

Hello!

I would like to add color to variables only if they are greater than 1. If not, leave them as they are.

My current formula is:

WITH epic_mds = actual / estimated: 

WITH wbs_mds = actual / budgeted: 

WITH wid_mds = actual / lastforecast: 

IF (estimated > 0 AND issuetype = "Epic"; epic_mds; 

IF (budgeted > 0 AND issuetype = "WBS"; wbs_mds; 

IF (lastforecast > 0 AND issuetype = "Work ID"; wid_mds; 

"" ) ) )

Is it possible on Jira Data Center?

Thanks in advance!

[Stepan Kholodov _Tempo_ · Accepted solution]

Hello @nbabin 

You can add more conditions to the formula that can look like this:

IF (estimated > 1 AND issuetype = "Epic"; concat("{color:red}",epic_mds,"{color}");

The Format of the column should be set as Wiki Markup for the coloring to be properly displayed.

I hope this helps. If you need further assistance or if you have other questions, as Valerie already suggested - please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)

[Valerie Knapp · Accepted solution]

Hi @nbabin , welcome to the Atlassian Community and thanks for your question.

Please refer to the product documentation here on how to achieve this - https://help.tempo.io/structure-dc/latest/wiki-markup-in-formula-columns .

If you are still having trouble, I always recommend to open a ticket to the vendor, who are best placed to advise about their products.

I hope this helps you.

Cheers