Due date of certain issue set to the due date of a certain sprint

[BenWade]

Hi everyone,

There are old posts related to this topic, but they are unclear.

I have several projects in Jira Premium Cloud: Projects A, B, C, and D. Each project has its own sprint. I want subtasks, tasks, bugs, and stories to automatically take the due date of the sprint based on the 'Sprint' field. I want an automation rule to check the 'Sprint' field of these issue types. If it is not empty, the rule should then check the end date of the sprint and set that as the due date for the issue.

There is an old post suggesting a method that only sets the due date if the sprint has already started, which is irrelevant to my needs. I need automation to set the due date even if the sprint has not started yet. I create sprints in advance, and my team works in 1-month sprints. For example, we currently have an active July sprint, and I am already assigning tickets to the upcoming August sprint. At the end of the month, I will close the July sprint, move open issues into the August sprint, and add extra issues from the backlog into the August sprint.

In summary, I want a flexible rule that sets the due date of issues based on the sprint indicated in the 'Sprint' field, regardless of whether the sprint has started or not.

#jirapremium

#jiracloud

#companymanaged

[Jeroen Poismans · Accepted solution]

Hi!

I've got a rule that does just that. It triggers on the Sprint field change:

As you can see I use a Smart Value sin the editing of the due date:

{{issue.Sprint.endDate.jiraDate}}

More info on Smart values can be found here:

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

Hope this helps!

[BenWade]

Could you please tell mem which step and where to add so I can choose specific issue types. I want this to work only for bugs and tasks

[Marc - Devoteam]

Hi @BenWade 

Use a condition before the edit action.

Condition:

[BenWade]

Thank you @Marc - Devoteam 🙌👍
I hope it is ok if I accept @Jeroen Poismans response.

Unfortunately, I cannot accept two answers.

[BenWade]

I am curious, I have end date 2nd of August

Why the automation sets the due date to 1st August

[Jeroen Poismans]

Hi Ben,

Might have something to do with End date being at 12:00AM? 

[Marc - Devoteam]

@Jeroen Poismans 

Could well be as I remember. You would need to specify 23:59 PM.