JIRA Structure Formula field is not calculating the IF condition properly for Progress & RAG status

Yatiraj Sharma November 21, 2022

I am using simple formula using IF function in my JIRA structure, however, It is not properly calculating IF condition and Progress column and always putting it as "Red" which is default value.  

IF( Progress > = 70; "Green"; "Red") 

Structure Error.PNG

1 answer

1 accepted

1 vote
Answer accepted
Yatiraj Sharma November 22, 2022

We have to use the below formula like this

IF(Progress > 0.7, "{panel:bgColor=#59B161}Green{panel}", Progress > 0.5, "{panel:bgColor=#FFAF00}Orange{panel}", "{panel:bgColor=#EF4B59}Red{panel}")


Structure solution2.PNGStructure solution.PNG

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events