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 P Claspill

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/