JIRA Connector, Fields with multiple values

fred sodergren

I have a sheet that reports on every ticket in a sprint. I'd like to know when a ticket has been in more than one sprint.

SS shows me one sprint (grey)

while JIRA shows multiple (+4)

Labels come across as a comma-separated list. Is there a way to get SS to show the sprints the same way?

Nathan Lloyd

Hi Fred,

I tried testing this myself and found the same result as you. Testing with the Jira API itself using Postman (to remove the variable of the Jira Connector by Smartsheet), I'm also seeing that results from Jira are returning only the current Active Sprint the Issue is a part of. See the example request payload below:

"sprint": {

            "id": 4,

            "self": "https://[redacted]/rest/agile/1.0/sprint/4",

            "state": "future",

            "name": "JTSSO Sprint 3",

            "originBoardId": 1

"closedSprints": [

            {

                "id": 3,

                "self": "https://[redacted]/rest/agile/1.0/sprint/3",

                "state": "closed",

                "name": "JTSSO Sprint 2",

                "startDate": "2020-03-11T14:54:27.844Z",

                "endDate": "2020-03-17T14:55:00.000Z",

                "completeDate": "2020-03-11T14:54:47.174Z",

                "originBoardId": 1,

                "goal": ""

It looks like past Sprint information is really stored in a "closedSprints" field in Jira at and unfortunately that doesn't look to be supported by the Jira Connector at the moment. Please do feel free to submit an Enhancement Request so the product team can be made aware of this.

Best,

Nathan L.

Nathan Lloyd

Hi Fred,

I tried testing this myself and found the same result as you. Testing with the Jira API itself using Postman (to remove the variable of the Jira Connector by Smartsheet), I'm also seeing that results from Jira are returning only the current Active Sprint the Issue is a part of. See the example request payload below:

"sprint": {

            "id": 4,

            "self": "https://[redacted]/rest/agile/1.0/sprint/4",

            "state": "future",

            "name": "JTSSO Sprint 3",

            "originBoardId": 1

"closedSprints": [

            {

                "id": 3,

                "self": "https://[redacted]/rest/agile/1.0/sprint/3",

                "state": "closed",

                "name": "JTSSO Sprint 2",

                "startDate": "2020-03-11T14:54:27.844Z",

                "endDate": "2020-03-17T14:55:00.000Z",

                "completeDate": "2020-03-11T14:54:47.174Z",

                "originBoardId": 1,

                "goal": ""

It looks like past Sprint information is really stored in a "closedSprints" field in Jira at and unfortunately that doesn't look to be supported by the Jira Connector at the moment. Please do feel free to submit an Enhancement Request so the product team can be made aware of this.

Best,

Nathan L.