Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,458,056
Community Members
 
Community Events
176
Community Groups

Jira Structure - formula columns

KS I'm New Here Nov 30, 2022

Hi,

 

Can you help me to create two formula columns in Jira Structure ?

The Hierarchy is:

  • Epic
    • Story
      • Subtask

The query for my Jira Structure is on subtasks level.

I want to make two formula columns where the remaining estimates and due date of the subtask it's parent issue (Story) is made visible.

Thanks a lot !

 

2 answers

3 votes

Hi @KS ,

Welcome to the community!

These should be rather simple formulae to write.  I would do something like this:

if type = "Subtask" : PARENT{due_date}

This will simply return the parent (story) due date field, but only on subtasks.

The other one is a little bit more complicated, as it has multiple conditions. 

if type = "Subtask" and !remaining_estimate : PARENT{remaining_estimate}

Here !reamaining_estimate means that the field is empty or 0.

Lastly you will want to change the format dropdown on the formulae to present the date and duration values correctly.  If the formula just returns a big number that is the first thing I would check.

Cheers,
Nick [Tempo/ALM Works]

Hi @Nicholas Ellis _ALM Works_  , 

 

Thanks for your answer !

 

PARENT{} is not working as no data is displayed.

Any idea why ?

 

Thanks a lot !

Kr,

Hi Klaas,

The PARENT{} function returns whatever field is in the brackets.  If it is empty I would expect it to return nothing.  If it was something like PARENT{some_field}, I would check that the some_field variable pointed to an existing Jira field with data.

If all of those things are true and it still doesn't work you might have an issue with your if condition or syntax.  Can you share the precise Expr formula you are using?

Cheers,
Nick [Tempo/ALM Works]

Like David Niro _Tempo_ likes this

Hi Nicolas,

image.png

When I remove PARENT{} , the due_date of the Subtask is made visible if it is set as expected. 

 

image.png

I also have a problem with e.g. issueLinks . Maybe I do something wrong here (I just copied the sample formula).

Could it be that I miss some libraries or extensions or something like that ?

image.png

 

Thanks a lot !!

Kr,

Hi Klaas,

The issuelinks array is only available with Structure on prem currently.  Your code is correct, but the platform is not.  Here is the link to our cloud documentation.

My apologies for the confusion.

Cheers,
Nick [Tempo/ALM Works]

Hi Nicholas,

Oww, that explains a lot. Sorry I hadn't seen this.

Thanks a lot !!

Kr,

0 votes
Dave Mathijs Community Leader Nov 30, 2022

Hi @KS welcome to the Atlassian Community!

Would you like a roll-up/aggregation of the Remaining Estimate from Subtask to Epic level?

Hi @Dave Mathijs

When there are no remaining estimates defined for the subtask, I want to have the remaining estimate of it's parent issue (story).

No remaining roll-up/aggregation of the Remaining Estimate from Subtask to Epic level, only story level.

Thanks !

Kr,

Suggest an answer

Log in or Sign up to answer