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

Ability to configure value format of values imported from text fields in Sheets

    XMLWordPrintable

    Details

    • Feedback Policy:

      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.

      Description

      Summary

      Currently, the Sheets integration uses Jira Cloud's API endpoints to retrieve data.

      When retrieving values from text fields, a string will be retrieved since that's the format returned by Jira's API endpoint.

      That's true even if the text field contains only number characters.

      As consequence, Sheets format the values as text on their side, and you won't be able to execute math functions towards those values, such as SUM.

      Suggestion

      Provide an option to import values from text fields as number in case they contain number only characters.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            lalmeida@atlassian.com Leonardo De Almeida
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated: