Need ability to report on 'Current Sprint' (in a single Sprint column) when exporting to CSV

[aokeeffe_guidewire_com]

We need ability to report on 'Current Sprint' (in a single Sprint column) when exporting to CSV. Currently if a Jira issue is moved from one sprint to another, the more sprints it gets pushed through, the more columns I end up having when exporting my filter view to e.g. CSV, and I first need to cleanup a number of columns to see that one currentsprint an issue is in...This is not user friendly and causes our reporting to be skewed and taking a lot of time to fix.

Is there anyway Customers come around this issue?

Thank you for help!

[Habib__Plugio__]

Hi @aokeeffe_guidewire_com ,

Unfortunately there's no native setting for this — the Sprint field stores every sprint the issue has been in, and CSV export writes each value to its own column.

Two workarounds:

1. Spreadsheet formula. The last non-empty Sprint column is the current one. In Excel: =LOOKUP(2,1/(B2:Z2<>""),B2:Z2) — adjust B2:Z2 to cover your Sprint columns.

2. Automation rule. Create a single-line text custom field (e.g. "Current Sprint"). Add a rule: trigger Field value changed on Sprint → action Edit issue, set the field to {{issue.Sprint.last.name}}. Then export that field instead of Sprint.

[Victor Law - Ricksoft]

Hi @aokeeffe_guidewire_com 

Jira does not natively support exporting multiple values from a field such as Sprint into a single CSV column, and you may refer to the following ticket from Atlassian:

https://jira.atlassian.com/browse/JRACLOUD-63747

However, you can try the Excel-like Bulk Issue Editor for Jira app, which lets you export multiple values in fields like Sprint into a single column.

Disclaimer: I work for the Ricksoft team that develops and maintains the Excel-like Bulk Issue Editor for Jira app

Could you share a little more about the report you're trying to create from the CSV? That will help us understand the expected output and suggest the best approach.

If your use case focuses on the current sprint, the app also provides an Active Sprint Filter, which lets you filter work items from all currently active sprints or select a specific active sprint before exporting the data.

You can find more details about the Active Sprint Filter here:
https://docs.ricksoft-inc.com/excel-like-issue-editor-for-jira-cloud/active-sprint-filter

Hope this helps!

Thank you.