nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How can I show only the last assigned sprint value in a structure?

Fatih Sahin

Hi Community,

As a Scrum Master, I am using a team structure to check if all the stories underneath a feature is planned in the upcoming sprints. I use a sprint column for that but it shows all previously assigned sprints in that field which makes the field filled in with a lot of values and hard to check the latest one. Is there any way that I can show only the latest greatest assigned sprint value of the story?

Accepted answers

Stepan Kholodov

Hello @Fatih Sahin

You can show only the last assigned sprint in the Formula column with this formula:
sprint.last()

It is possible to apply additional filtering conditions if needed. For example, to exclude Closed Sprints completely and show the last Active/Future assigned Sprint like this:
sprint.filter($.state != "closed").last()

I hope this helps. If you need further assistance with this or help with anything else, please reach out to us directly at our portal: https://tempo-io.atlassian.net/servicedesk/customer/portal/6/group/1051

Best regards,
Stepan Kholodov
Tempo

All comments

Stepan Kholodov

Hello @Fatih Sahin

You can show only the last assigned sprint in the Formula column with this formula:
sprint.last()

Best regards,
Stepan Kholodov
Tempo

Fatih Sahin

Hi Stepan,

You can not predict how much happy you made me with that answer. It works very well! My suffer is fully healed! Thanks a lot for your help! I am too appreciated!

Fatih Sahin

@Stepan is there a way also to sort the items in ascending order based on that custom column I created with that formula? I made a new column with the formula you shared and named it as "Last Sprint". Can I order all the rows based on that "Last Sprint" values? I could not find an option to do that. Can it be done by coding maybe?

Stepan Kholodov

@Fatih Sahin
Sure, you can do it by simply clicking on the Formula column's name(clicking on it again will reverse the sorting order). But in this case, the formula should be like this: sprint.name.last() for achieving the right sorting.

Also, if you have any generators in the structure, the Automation button should be clicked on to hide the list of the generators at the top of the structure(this enables the sorting by columns).

Best regards,
Stepan Kholodov
Tempo

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-software

structure

addon-com.almworks.jira.structure

jira-software-server

sprint