Jira Structure - Formula to display child's status

Fanny Zucchinetti

Hi all, 

I would like to enhance my structure to better report the status of our epics. 

We created one refinement Task per epic and I would like to create one column with a formula to show, on the epic row, the status of this refinement task. The goal is to have a list of epic with a column with the refinement status (like in the screenshot, if we would collapse at level 2 and see only the epics). 

Can you help me to write this formula? 

Thanks a lot, 

Fanny

David Niro

Hello @Fanny Zucchinetti ,

David from ALM Works here.  Welcome to the Community!  

It looks like you are using an on-prem version of Jira and Structure.  If this is correct, then the following solution will work for you.

What we will do is use your original formula as a variable in another formula.  This one will roll the value of the formula you have created up to the Epic level.

IF (Issuetype = "Epic",MAX#children{Refinement_Status})

After doing this, "Refinement_Status" will be red and you will see it in a list of Variables under the formula.

Click on "Refinement_Status" in the list of variables and type "Formula".  You should now have a new Formula box.

Paste your first formula into this box and save.

You should now see the Status of your Task w/ Label "Refinement" at the Epic level.

Please let me know if this works for you!

Best,
David