Set First Sprint and Last Sprint for an Issue with Automation

[Yuliia Zhyliaieva]

Hi, I have separate custom fields FirstSprint and LastSprint. When an issue moves from sprint to sprint, I need to see in these fields, when it was first picked up (FirstSprint), and when in was finished (LastSprint).

Can't figure out the automation rule

This does not work:

{{issue.Sprint.name.split("").last}}

{{issue.Sprint.name.split("").first}}

Return weird values. For instance, issue was picked up in Sprint 10 and now it's sprint 20 (experimental sprints), and the rule will print Sprint 12 as the first sprint, and Sprint 14 as the last one. Can't figure out the logics

[JD · Accepted solution]

Hi @Yuliia Zhyliaieva ,

There are a few ways you could set the first sprint custom field. One way (which works for setting both first and last sprint) is using the issue status to update your custom field. 

However you might decide you want to set the First sprint field for issues that are in TODO (not just when an issue transitions from TODO to In progress). For this case you could trigger the automation when a sprint is started and use a JQL branch (using smart values in your search) to set the First sprint field for all the issues in the sprint.

Hope that helps!

- John