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.
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?
I am having the same problem. It doesn't seem to be a real lookup. It appears rather a copy pasting of some lists.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.