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 · Accepted solution]

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

[Fanny Zucchinetti]

Hi @David Niro ,

Thanks a lot for your answer, it works perfectly :) 

Best regards, 

Fanny

[Dave Rosenlund _Trundl_]

Hi, @Владимир Лебедьков (and @Fanny Zucchinetti.

Honestly, the ALM Works support team is happy to respond here.  One of our Structure Formulas experts will chime in here shortly, I'm sure. 

-dave 

[Jan Popelák]

Hello @Fanny Zucchinetti

here is one row sollution:

TEXT(epicStories.FILTER($.Labels.CONTAINS("Refinement") and $.issuetype = "Task").Status)

Have a nice day, Jan

[Владимир Лебедьков]

Hi
I recommend asking this question in the Structure Telegram channel
https://t.me/structure_community