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; } } }

In the Excel plug, how to use cell references in JQL?

Tom Gagne_ylsrl5

The plug-in opens a window on the right and gives me the opportunity to enter JQL directly into the "JQL Query" text-entry field. Is there a way to use cell references in that query from another tab?

Specifically I have another tab (named "Weeks") that contains a from- and to-date fields. I would like to use them in my JQL. Something similar to:

status changed to "Dev Complete" during("&Weeks!b6", "&Weeks!c6")

Accepted answers

All comments

Bill Sheboy

Hi @Tom Gagne

Please take a look at the examples in this question's solutions, as I believe you are missing some ampersands to make the query concatenate correctly and use of nested quotation marks:

https://community.atlassian.com/t5/Jira-Software-questions/How-to-reference-cells-in-JIRA-function-for-Google-Sheets/qaq-p/1581545

Kind regards,
Bill

Tom Gagne_ylsrl5

Bill, that might work for =JIRA.SQL() but I haven't been able to get it working for the textarea box. Have you?

Bill Sheboy

No, I have only done it as mentioned in that other post or with saved filters.

What happens if your remove both the quotation marks and ampersands: will the plugin resolve it then?

status CHANGED TO "Dev Complete" DURING ( Weeks!$B$6, Weeks!$C$6 )

Tom Gagne_ylsrl5

Bill, good point. If I try without quotes it complains about the "!" If I try with quotes I get:

Date value 'Weeks!$B$6' for predicate 'during' is invalid. Valid formats include: 'yyyy/MM/dd HH:mm', 'yyyy-MM-dd HH:mm', 'yyyy/MM/dd', 'yyyy-MM-dd', or a period format e.g. '-5d', '4w 2d'.; Date value 'Weeks!$c$6' for predicate 'during' is invalid. Valid formats include: 'yyyy/MM/dd HH:mm', 'yyyy-MM-dd HH:mm', 'yyyy/MM/dd', 'yyyy-MM-dd', or a period format e.g. '-5d', '4w 2d'.

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

jql

ms-excel