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

Question

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!

Valerie Knapp_dpp5c6 · Accepted Answer

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

Stepan Kholodov · Accepted Answer

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)