Are you in the loop? Keep up with the latest by making sure you're subscribed to Community Announcements. Just click Watch and select Articles.

Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Date from the latest sprint from an issue


I am wondering how I can get endDate from the newest spring assigned to the issue?


I have an automation which updates Issue `Due date` when new sprint is added to the issue.


Problem is that issue can have more than one sprint and that smart value return endDate from the oldest Sprint.

2 answers

1 accepted

2 votes
Answer accepted
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Sep 22, 2023 • edited

Hi @Bartlomiej Bukowski 

Until a sort option/function is added to lists, we cannot rely upon first and last for a scenario like yours.  (The exception is when you do have a sort, ORDER BY, for things like lookup issues with JQL.)

For your scenario, let's assume your newest sprint is the one which ends the latest.  If that is the case, you can use this:


If that does not work for some reason, there is a much more elaborate work-around, using a REST API call and smart value, list filtering.  Hopefully you will not need that one  :^)

Kind regards,

Hi Bill,

Thank you for your support.
Your suggestion solved my issue.

Smart values used by me:
- for start date:
-for end date:

Best regards,

Like Bill Sheboy likes this
1 vote
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Sep 22, 2023

Hi @Bartlomiej Bukowski , try using the "last" function.


Hi Jack, 

I tried both



It will give different date but not from the current sprint.

- Issue has already Sprint1 and Sprint2 set up
- Adding Sprint3
- DueDate set on issue changes to the date from Sprint2 and not from Sprint3.

Old smart value which is

will set up DueDate from Sprint1

There is a progress but it's not the solution yet.

Suggest an answer

Log in or Sign up to answer
Site Admin
AUG Leaders

Atlassian Community Events