Use JQL in GDocs with Key as dynamic filed.

[Julio Bianco]

Hey guys, i'm trying to have the status for each ticket that I have in a Sheet on google docs.  Is it possible to pass the key in the argument, indexing a cell with key number?

For exemple, I have the key number (BAC-123) in the cell A2 in my Google Sheet

Instead of This

=INDEX(JIRA("KEY=BAC-123");2;4)

I need to do this

=INDEX(JIRA("KEY=A2");2;4)

[Stephen Sifers · Accepted solution]

Hello Julio!

Interesting idea to pass through cell data into another cell to generate a JQL statement.

I believe you can do this within google sheets using the 'CONCATENATE' function. Ideally, it'll look like this:

For this example, I removed the '=' so I could show it together, sImply add '=' as follows;

=CONCATENATE(=,A4,A9,A5)

I hope this proves helpful in getting the information you need.

Regards,
Stephen Sifers

[Julio Bianco]

Hi, Stephen.
Thanks for the response.
I've tried to concatenate same as you, but the GDoc do not recognize it as a formula.

But anyhow, thanks for the help, I'm using a sheet with Jira information and doing a VLOOKUP to insert the status in my mains table. :)