How to reference a cell inside the JIRA() function?

[Vinicius Correia]

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!

[Bertrand Germain]

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,