I am trying to fetch issues in a particular sprint using SPRINT NAME or SPRINT ID in Google sheets and below is the query along with sample output.
I get records with matching sprint ID/name but also issues with additional sprint names (1st record)
Question: How do I avoid getting multiple sprint names in the output? (Yes, the issues have multiple sprints tagged and its not a good practice...)
I just want the output where in, only sprint is 234 or issues with multiple sprints tagged but sprint 234 top most sprint.
=JIRA(CONCATENATE("Sprint =234 AND project=PRJ" ), "issueKey,Sprint, summary, ", 0, 30)