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

=JIRA() function stops working with showing error "Unknown function: 'Jira'"

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Low Low
    • None
    • 1.0
    • Jira Cloud for Google Sheets
    • None
    • Severity 3 - Minor

      Issue Summary

      When a user tries to use =JIRA() function in Google Sheets (with the app Jira Cloud for Sheets) it throws an error "The Unknown function: Jira"

      Steps to Reproduce

      1. Currently unable to reproduce the issue

      Expected Results

      =Jira() function should work and users able to write JQL and pull data into a sheet

      Actual Results

      Instead, users get this error: Unknown function: 'Jira'

      Workaround

      This is an intermittent issue in Google Sheets. Re-applying the add-on on the sheet might help to resolve the issue. To do this, click Extensions —> Add-ons —> Manage Add-ons in the top menu and then uncheck and check “Use in this document” on Jira Cloud add-on.

      Note

      If possible please provide a screen recording with the browser console open and show us if there are any warnings or errors. This might be useful for us to see if there’s anything we can reproduce the issue.

        1. image-2023-05-31-09-42-00-282.png
          image-2023-05-31-09-42-00-282.png
          16 kB

            [API-669] =JIRA() function stops working with showing error "Unknown function: 'Jira'"

            aldo.salas added a comment - - edited

            Hello, I'm also facing this problem.

            For repro steps:

            • Simply open a sheet where the function is used in a formula and the error message is displayed: Unknown function: 'jira'.

             

            I've configured the add-on to update daily if that makes any difference.

            aldo.salas added a comment - - edited Hello, I'm also facing this problem. For repro steps: Simply open a sheet where the function is used in a formula and the error message is displayed: Unknown function: 'jira'.   I've configured the add-on to update daily if that makes any difference.

              Unassigned Unassigned
              06dacf0511be Rahul
              Affected customers:
              5 This affects my team
              Watchers:
              5 Start watching this issue

                Created:
                Updated: