Ok, there is a lot of filtering using functions to find carryover stories, but I think there are two use cases and I'm trying to solve both.
Use case 1: when closing a sprint and there are stories not done, Jira asks if you want to carryover these stories to the next sprint. If you carry them over, then filtering for these is easy and you can see multiple sprints listed in the story itself. Export to excel, then do the excel thing to single out stories with multiple sprints.
Use case 2: After starting a sprint, a story is moved into the next sprint. This is not considered a 'carryover' story and therefore does not show in use case 1 filtering. I have a story that was in 2 previous sprints and now in the current sprint. I can see the changes in the stories history, but Jira doesn't show multiple sprints when looking at the stories 'Active Sprint' data, only shows current sprint.
How do I get results for use case 2? I've already tried the function 'removedAfterSprintStart'
Everything I try results in only the current sprint being displayed.
