Use affected version in Formula in structure

[Els Vercauteren]

In a structure i have a matrix where columnlabels are affected versions we have (our list 2024Q1 ; 2024Q2 : 2024Q3 : 2024Q4 : 2025Q1 ; ...)

The colouring in cell in column on row needs to be pulled from field we have (psr_colouring)

What i need

If the affectedversion is = columname => current version => cell to be filled

If the affectedversion is > columname => future version ==> cell to stay empty

----

If future version formula needs to give empty ; If current version formula needs to give the field psr_colouring.

I now have the below but i don't seem to be able to get defined what is past, current, future affected version in the formula as is (see below)

Any idea ?

formula

If affected_version = "2025Q3" :

(

if issuetype = "featuregroup" :

if psr_colouring = "Red" : {panel:bgcolor=#EF4B59}RED{panel}"

ELSE : 

if psr_colouring = "Amber" : {panel:bgcolor=#FFAF00}AMBER{panel}"

ELSE :

if psr_colouring = "Green" : {panel:bgcolor=#ADFF2F}GREEN{panel}"

)

ELSE :

if issuetype = "featuregroup" : affected version

[Valerie Knapp · Accepted solution]

Hi @Els Vercauteren , thanks for your question. I just tagged Structure into the discussion as well.

Generally, for specific cases like these, I recommend to contact the vendor directly, especially if you have a paid license, as they are the best placed to help. https://marketplace.atlassian.com/apps/34717/structure-by-tempo-jira-portfolio-management-ppm?hosting=cloud&tab=support 

^ This page has their contact details as well as a link to the product documentation where you might also find some useful information.

Cheers