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.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.