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
Community Members
Community Events
Community Groups

How can i find a user story is in multiple sprint in JIRA structure

I want to list the user stories which are in multiple sprints 

1 answer

1 accepted

1 vote
Answer accepted

Hello @Parveen Taj ,

David from ALM Works here.

Are you trying to create a structure that includes only stories that are included in multiple sprints?

Or, are you trying to mark/identify stories that already exist in a structure and are assigned to multiple sprints?


I already have a structure with user stories , now I want to view only those which are in multiple sprints

Hello @Parveen Taj ,

Thank you for the clarification!

You can use a formula like the one below to identify the issues that are part of more than one sprint:

IF sprint.SIZE() > 1:

If you are using an on-prem version of Structure, which it appears you are, you can also Filter by this formula.

You can add a Generator or Transformation and choose Filter by Attribute.  Use the formula above as your attribute and set the Operator to "is true".

Please let me know if this helps!


yes it works :-)  thank you so much ... how do I highlight this in Red  colour for more visibility

Hello @Parveen Taj ,

So glad to hear it!  You are very welcome!

You can use this formula:

with sp_size =

IF sp_size >1:

Make sure to change the format from General to Wiki Markup for it to work.  I also made an adjustment that shows the number of sprints rather than just a 1.


Excellent Thanks you..

Like David Niro _ALM Works_ likes this

Suggest an answer

Log in or Sign up to answer