Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Track status for jira+google sheets integration

Brandon Sineff
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 7, 2022

I am looking for a solution to the following problem. 

I am trying to pull just the "status" from a Jira link located in a specified cell. ]

The formula used in google sheets previously worked but now they do not.

  • =INDEX(JIRA(("issueKey = "&[Cell number]), "status"),2,1)
    or in full context
  • =INDEX(JIRA(("issueKey = "&A256), "status"),2,1)

I am unsure on what made this change, but I am successfully logged into my environment and this worked previously. but now, all I get are... #REF! errors stating

Error:Function INDEX parameter 2 value is 2. Valid values are between 0 and 1 inclusive.

Invalid:Input must be an item on the specified list

Where multiple items in Atlassian forums show 2,0 for the index or other. 

Could I get a little insight on the direction of information?

1 answer

1 vote
Pablo Ausobsky
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 6, 2023

I am having the same problem. It doesn't seem to be a real lookup. It appears rather a copy pasting of some lists.

Suggest an answer

Log in or Sign up to answer