nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

Lucas Modzelewski _Lumo_

Did you try experimenting with sheets today function?

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

All comments

Lucas Modzelewski _Lumo_

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:

Zrzut ekranu 2024-12-18 092944.png

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud