How to get a SUM of Sprint an issue has been with Jira Automation

[Marcel Munerotto]

Hello

I'm completely lost and have no idea how to proceed. And Google doesn't really help because I'm always finding solutions to sum the story points of Jira Issues, but that's not what I want to do.

I have a text field sprint_count, and I want to write down the number of sprints this issue has been in during its lifetime. I want to see within a JQL query which issues my team doesn't finish / succeeds in finishing.

I'm quite sure that it's possible to do something with Jira Automations, but I'm not experienced enough to do it, and now I hope someone here has an idea how to do it.

[Trudy Claspill · Accepted solution]

Hello @Marcel Munerotto 

If I understand correctly, you want an Automation Rule that will set a sprint_count field in each issue to the number of sprints to which that issue has been assigned. Is that correct?

It that is correct, you can get the count of Sprints to which an issue has been assigned (and never removed) with this smart value:

{{issue.Sprint.size}}

The Sprint field is a list. This page talks about the attributes you can reference for a list object.

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-lists/

[Marcel Munerotto]

Hello Trudy

that was even easier than I thought. I thank you very much! The linked page I did find, but was unable to make the connection to sprints.

Your help is greatly appreciated.