Uploaded image for project: 'Atlassian Product Integrations'
  1. Atlassian Product Integrations
  2. API-24

Custom field 'Sprint' not showing proper format

XMLWordPrintable

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      For Sprint custom field, it is doing a data dump into the field.  Would prefer to display the name of the sprint rather than the name along with all the metadata.

      Here is a workaround shared by the customer who reported the issue to us:

      =iferror(right(index(split(<cell reference>, ",", TRUE,TRUE), 0,4),LEN(index(split(<cell reference>, ",", TRUE,TRUE), 0, 4))-5),)

      Note:  Additional info is not included here since this is a public board, but has been included in issue created in Jira Cloud for Google Sheets project backlog

            [API-24] Custom field 'Sprint' not showing proper format

            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow [ 3116009 ] New: JAC Suggestion Workflow 3 [ 3588323 ]
            Status Original: RESOLVED [ 5 ] New: Closed [ 6 ]
            Tanguy Crusson made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: Gathering Interest [ 11772 ] New: Resolved [ 5 ]

            Tanguy Crusson added a comment -

            The add-on now returns a list of sprints, delimited by semi-colon, ordered by sprint creation date. 

            You can use Sprint (returns a list of names), Sprint.name, Sprint.id (returns a list of ID), sprint.startDate, sprint.endDate, sprint.completeDate

            For example:

            =JIRA("some JQL", "key, sprint.name")

            Tanguy Crusson added a comment - The add-on now returns a list of sprints, delimited by semi-colon, ordered by sprint creation date.  You can use Sprint (returns a list of names), Sprint.name, Sprint.id (returns a list of ID), sprint.startDate, sprint.endDate, sprint.completeDate For example: =JIRA("some JQL", "key, sprint.name")
            Kristin Hamilton (Inactive) made changes -
            Description Original: For Sprint custom field, it is doing a data dump into the field.  Would prefer to display the name of the sprint rather than the name along with all the metadata.

            Here is a workaround shared by the customer who reported the issue to us:

            =iferror(right(index(split(<cell reference>, ",", TRUE,TRUE), 0,4),LEN(index(split(<cell reference>, ",", TRUE,TRUE), 0, 4))-5),)

            _*Note*:  Additional info is not included here since this is a public board, but has been included in issue created in Jira Cloud for Google Sheets project backlog_             		New: For Sprint custom field, it is doing a data dump into the field.  Would prefer to display the name of the sprint rather than the name along with all the metadata.

            Here is a workaround shared by the customer who reported the issue to us:
            {code:java}
            =iferror(right(index(split(<cell reference>, ",", TRUE,TRUE), 0,4),LEN(index(split(<cell reference>, ",", TRUE,TRUE), 0, 4))-5),){code}
            _*Note*:  Additional info is not included here since this is a public board, but has been included in issue created in Jira Cloud for Google Sheets project backlog_
            Kristin Hamilton (Inactive) made changes -
            Description Original: For Sprint custom field, it is doing a data dump into the field.  Would prefer to display the name of the sprint rather than the name along with all the metadata.

            _*Note*:  Additional info is not included here since this is a public board, but has been included in issue created in Jira Cloud for Google Sheets project backlog_             		New: For Sprint custom field, it is doing a data dump into the field.  Would prefer to display the name of the sprint rather than the name along with all the metadata.

            Here is a workaround shared by the customer who reported the issue to us:

            =iferror(right(index(split(<cell reference>, ",", TRUE,TRUE), 0,4),LEN(index(split(<cell reference>, ",", TRUE,TRUE), 0, 4))-5),)

            _*Note*:  Additional info is not included here since this is a public board, but has been included in issue created in Jira Cloud for Google Sheets project backlog_
            Kristin Hamilton (Inactive) created issue -

              tcrusson Tanguy Crusson
              khamilton@atlassian.com Kristin Hamilton (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: