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
