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

            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")

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

                Created:
                Updated:
                Resolved: