Dynamically fetch status from jira into google sheet based on key present in a specific cell

Sulbha Srivastava March 2, 2022

=QUERY(JIRA(CONCATENATE(S1,"KEY=",<CellNumber>,S1),"Status"),"SELECT * OFFSET 1",0)

Can some suggest why data is not being fetched using above query. Using google sheets with Jira function

0 answers

Suggest an answer

Log in or Sign up to answer