Use JQL in GDocs with Key as dynamic filed.

Question

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 Answer

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