Jira Google Sheet add-in #REF error

Marcelo Sosa July 12, 2021

Hi everyone, 

Let´s see if anyone can help.

All white cells have formulas. Like this one: =INDEX(jira("issuekey = PROY-972", "Prioridad"),2,0) this formula it´s used to retrieve the value Priority within a single cell for the issue PROY-972. And it works perfectly fine.

The problem: 

Surprise is when I close the page and got back to it, it returns me this #REF error. If I copy and paste the same formula in the same cell, the error disappears and it gives me back the value as it did in the first place.

This is a report for management, and it´s worthless with all these errors showing up.

 

I wonder if anyone can provide insight into this. 

Thank you in advance for your time.

Marcelo

 

Jira.JPG

0 answers

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events