Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

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

Sulbha Srivastava
Sulbha Srivastava
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Get involved
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

Answer
Watch
Like Be the first to like this
627 views

0 answers

Suggest an answer

Log in or Sign up to answer
Jira
Jira
TAGS
AUG Leaders

Atlassian Community Events

    See all events