• Type: Bug
• Resolution: Unresolved
• Priority: Low
• Fix Version/s: None
• Affects Version/s: 1.0
• Component/s: Jira Cloud for Google Sheets
• Labels:

  None

1. 

   image-2023-05-31-09-42-00-282.png

   16 kB

   30/May/2023 11:42 PM

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

Andy Launer made changes - 21/Feb/2024 8:35 PM

Summary

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

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

Collapse comment: aldo.salas added a comment - 09/Feb/2024 10:09 PM, Edited by aldo.salas - 09/Feb/2024 10:10 PM

aldo.salas added a comment - 09/Feb/2024 10:09 PM - 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.

Expand comment: aldo.salas added a comment - 09/Feb/2024 10:09 PM, Edited by aldo.salas - 09/Feb/2024 10:10 PM

aldo.salas added a comment - 09/Feb/2024 10:09 PM - 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.

Vitalii Saienko (Inactive) made changes - 31/May/2023 9:11 AM

Description

Original: h3. Issue Summary When user tries to use =JIRA() function in Google sheets (with the app Jira cloud for Sheets) it throws error "The Unknown function: Jira" h3. Steps to Reproduce  # Currently unable to reproduce the issue h3. Expected Results =Jira() function should work and users able tp write JQL and pull data into sheet h3. Actual Results Instead users get this error: Unknown function: 'Jira' !image-2023-05-31-09-42-00-282.png|width=343,height=172! h3. Workaround Currently, there is no known workaround for this behaviour. A workaround will be added here when available {panel:title=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. {panel}

New: h3. 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" h3. Steps to Reproduce  # Currently unable to reproduce the issue h3. Expected Results {{=Jira()}} function should work and users able to write JQL and pull data into a sheet h3. Actual Results Instead, users get this error: Unknown function: 'Jira' !image-2023-05-31-09-42-00-282.png|width=343,height=172! h3. 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. {panel:title=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. {panel}

Vitalii Saienko (Inactive) made changes - 31/May/2023 9:07 AM

Status

Original: Needs Triage [ 10030 ]

New: Gathering Impact [ 12072 ]

Rahul made changes - 31/May/2023 12:26 AM

Description

Original: h3. Issue Summary When user tries to use =JIRA() function in Google sheets (with the app Jira cloud for Sheets) it throws error "The Unknown function: Jira" h3. Steps to Reproduce  # Currently unable to reproduce the issue h3. Expected Results =Jira() function should work and users able tp write JQL and pull data into sheet h3. Actual Results Instead users get this error: Unknown function: 'Jira' !image-2023-05-31-09-42-00-282.png|width=343,height=172! h3. Workaround Currently, there is no known workaround for this behaviour. A workaround will be added here when available {panel:title=Note} Please request to record a video 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. {panel}

New: h3. Issue Summary When user tries to use =JIRA() function in Google sheets (with the app Jira cloud for Sheets) it throws error "The Unknown function: Jira" h3. Steps to Reproduce  # Currently unable to reproduce the issue h3. Expected Results =Jira() function should work and users able tp write JQL and pull data into sheet h3. Actual Results Instead users get this error: Unknown function: 'Jira' !image-2023-05-31-09-42-00-282.png|width=343,height=172! h3. Workaround Currently, there is no known workaround for this behaviour. A workaround will be added here when available {panel:title=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. {panel}

Rahul created issue - 30/May/2023 11:46 PM