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?
