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
4,298,381
Community Members
 
Community Events
165
Community Groups

How to automatically populate Start date and End date based on Sprint value?

I have a Jira use case that I’m wondering if someone can help solve.

For starters, we are using BigPicture add-on that creates custom fields Start date and End date, which we have added to our Story screens.

We also use the standard Sprint field on Story screens.

What we’d like to do is create automation that would automatically set the Start date and End date values to be populated with the dates of the relevant Sprint value.

Example: if Sprint = September.2020 then Start date = Sep 1 and End date = Sep 30.

Of course, we would need Jira to know that Sep 1 and Sep 30 are the start and end dates of the Sprint, since that info is not collected in Jira.

What do you think?

Anyone have any first-hand knowledge or experience solving such a use case?

Thanks in advance!

Gil

3 answers

For the active Sprint, this can be achieved via Jira automation, which is free (limited triggers) and comes out of the box.

  • You can set condition for "Field value changed"
  • Then in action select "Edit Issue" 
  • Select end date field and set value as "{{issue.Sprint.endDate.jiraDate}}"

To edit future Sprint date with below API

URL: https://yourinstance.atlassian.net/rest/agile/1.0/sprint/Sprintid

{ "id": , "state": "FUTURE", "name": "xxxx", "startDate": "2020-10-07T15:22:00.000+10:00", "endDate": "2020-10-20T01:22:00.000+10:00"}

 

Sprint REST API documentation link

https://developer.atlassian.com/cloud/jira/software/rest/api-group-sprint/#api-agile-1-0-sprint-sprintid-put

 

Hi @Gil Vinokoor and @Astrid Uttenreitter 

This is easily achievable by using BigPicture's Task period alignment feature. Please refer to this wiki page for an extensive explanation on how to use it. 

I hope that this clarifies. Nonetheless, I rest at your disposal if any further doubts arise. 

Best regards,

Mateusz Sołowianiuk

SoftwarePlant Support

Nice to hear from SoftwarePlant, Mateusz!

This seems to be a new feature in BigPicture 8 (using Boxes), yes?

Like Mateusz Sołowianiuk likes this

Not really, Gil. We used to have the same functionality in earlier versions, please see this wiki page for more details. As you can see, the concept is pretty much the same - in BigPicture 8 we only refurbished this functionality so that it follows the Boxes logic. 

I hope that this clarifies. 

Best regards,

Mateusz Sołowianiuk

SoftwarePlant Support 

I am looking at the exact same thing, as currently it is not possible to add start/end dates to a sprint before it has started. 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

An update on Confluence Cloud customer feedback – June 2022

Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...

183 views 1 3
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you