Structure: use a filter in a formula for a column

Martin Härri March 9, 2024

I have defined a filter which filters for issues in a sprint of the current increment (meaning that the sprint name contains "I99"). I would like to use that filter in a column in structure, so I can display and sum up story points for those issues which have already been assigned to a sprint (something like "If filter = "Issue in sprint current increment", story points, 0).

Is that possible, can I use an existing filter in a column (I know that the formula syntax is not JQL, but EXPR)

1 answer

1 vote
Stepan Kholodov _Tempo_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 11, 2024

Hello @Martin Härri 

If you want to only consider Story Points of issues that are assigned to a Sprint with 'l99' in its name, you can use a formula like this:

if sprint.filter(search("l99",$.name)): storypoints

I hope this helps. If you need further assistance or have other questions about Structure, please reach out to us directly at our support portal.

Best regards,
Tempo (the Structure app vendor)

Martin Härri March 11, 2024

Thank you Stepan, I think we are getting closer, but not quite there yet. I have a filter which is called "Issues in Sprints of current increment", which is something like "sprint = I99 AND type in (story, bug, task)". This filters all stories, bugs and tasks where the sprint name contains I99.

I would now like to reference that filter in a column of the structure, with something like "If filter = "Issues in Sprints of current increment", then story points, else zero". I.e. if the issue meets the criteria, the field will display the story points of the issue, otherwise zero.

The reason why I don't want to have the filter criteria directly in the formula is that I have lots of different filters, boards and structures which would need to be updated every 3 months when we go to a new increment. So I created a "master filter" called "Issues in Sprints of current increment", and I only need to update this one, then all other filters, and boards and structure which use that master filter are automatically updated.

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events