Using parameters with Jira Cloud for Sheets

[Fabio.Cabral]

Hello!

I'm using the "Jira Cloud for Sheets" extension and running a macro that calls the "JIRA" function from a cell. The function looks like this:

'=JIRA("(project = FP AND issuetype in (Story, Task, Bug) AND resolutiondate >= 2024-10-28)", "key,summary,issue type,status,Created,resolutiondate")

My question is: how can I provide the resolutiondate as a parameter instead of hard-coded?

[Lucas Modzelewski _Lumo_ · Accepted solution]

Did you try experimenting with sheets today function? 

https://support.google.com/docs/answer/3092984?sjid=9854440490088339623-EU 

[Lucas Modzelewski _Lumo_]

Somehow I was thinking that you want to pass date from sheets ;) 

for JQL function check: https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#startOfDay-- 

[Fabio.Cabral]

I was looking for something like this:

• Cell B1: the JIRA function with a reference to cell B2 (resolutiondate >= B2)
• Cell B2: the resolution date

But I don't know how to do this :'(

[Lucas Modzelewski _Lumo_]

can be done, but not directly, you need to change your parametr to text before you send it to Jira (and make sure it matches Jira date format)

here is some basic example with formulas used:

[Fabio.Cabral]

Thanks @Lucas Modzelewski _Lumo_!!!