nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Jira Structure - formula columns

unknown

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 !

Accepted answers

All comments

Dave Mathijs

Hi @[deleted]welcome to the Atlassian Community!

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

KS_8j0pdg

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,

Nicholas Ellis _ALM Works_

Hi @[deleted],

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]

KS_8j0pdg

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,

Nicholas Ellis _ALM Works_

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]

KS_8j0pdg

Hi Nicolas,

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

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 ?

Thanks a lot !!

Kr,

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

structure

addon-com.almworks.jira.structure

expr

formula