Hello there,
I am using the JIRA function to retrieve some data and I would like to know if I can make some of the parameters dynamic (values presented in certain cells).
The query is:
JIRA("project=SI and issueType in ('Bug', 'Investigation Ticket') and component = 'mobile' and priority = 'Blocker' and created <= '2020/02/17' and (resolutiondate > '2020/02/16' or resolution = 'Unresolved')")
And I would like to have the component, created and resolutiondate values being retrieved from other cells so I could make them dynamic instead of static.
Does anyone know how to do it?
Thanks in advance!
I may be real late and you may have found your answer on this maybe it can help someone else.
You can use the & to concatenate a string with the content from another cell like this :
JIRA("project="&B2)
Hope it helps.
Best,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.