Re: Jira Cloud for Sheets : use "AND Status WAS ... ON dd...

Question

OK, I am trying something that should be much simpler, but I can not seem to get to work:

This works:

=JIRA(CONCAT("project=",Project_Data!$B$2), "summary, issuekey, priority, reporter, assignee, timeoriginalestimate, timeestimate, timespent, issuetype, customfield_10009, labels, resolution, status, resolutiondate, created, duedate, customfield_11700, fixVersions, customfield_11100, project")

But this throws an error:

=JIRA(CONCAT("project=",Project_Data!$B$2, " ORDER BY issuekey asc " ), "summary, issuekey, priority, reporter, assignee, timeoriginalestimate, timeestimate, timespent, issuetype, customfield_10009, labels, resolution, status, resolutiondate, created, duedate, customfield_11700, fixVersions, customfield_11100, project")

All I am trying to do is to sort the results by issue key - any ideas?

Earl McCutcheon · Answer

Awesome thanks for the confirmation :)

Judah Ferst_ig498k · Answer

Hi - adding those spaces worked! Thanks so much!

Earl McCutcheon · Answer

Hi @Judah Ferst ,

Thanks for the update and I'm looking at this now but just a heads up, I moved your question and of conversation chain to a new thread so we can focus the answer on an independent post, as the initial question is only partially related to what you are seeing  and this will help others find the different answer easier in the future depending on search terms used.

But The error you are seeing now looks like what would occur if the source cell had a formatting error, and I was able to reproduce the error by pointing a "=CONCATENATE(Sheet1!A1,test)" where sheet1 A1 contained a syntax error already rendering as "#ERROR"

But to get a better understanding of the failure point, What is the query or data point you have in the Project_Data sheet in cell B2?

Also if you run just the concatenate portion of the formula in the second sheet does the returned value look correct as it might be a spacing issue, try with the following format that adds in a couple white spaces around "project =" and the " Order By" clause from what it looks like is happening in the screenshot:

=CONCATENATE("project = ",Project_Data!B2," ORDER BY issuekey asc")

Regards,
Earl