e93e43186bc1 Thanks, I updated my example to show worklog.  You can submit a ticket from within the add-on by selecting "Give feedback" and select the "Ask a question" option.

Hi @AlexC,

Are you sure about the "Log Work" name ?
When I look at the fields in my project I have "worklog" so I queried worklog.authorDisplayName and not Log Work.AuthorDisplayName

I just tried your Jira formula and I got a "no field found" as values for my worklog subfields.

Where can I create an help ticket ?

Hi e93e43186bc1,

It does work with the =JIRA() formula.  Here is an example that works:

=jira("project=RAH","issuekey, summary, worklog.AuthorDisplayName, worklog.timeSpent",0,100

 
If it's not working for you please feel free to submit a help ticket with your particular example.

It doesn't work using the =JIRA() formula 

I can't query for example : worklog.authorDisplayName.

Any idea if this is gonna be fixed or if this won't be possible at all ?

Related post about worklog:  https://community.atlassian.com/t5/Jira-questions/Want-to-save-16-hours-when-you-export-worklog-data-from-Jira/qaq-p/1298796

Good news ... the worklog field is available!  You can find the worklog subfields that are supported if you go to the Fields tab, Edit the fields, and search for worklog.

Any ETA on this?

+1

Hi Catherine and others,

we are also V E R Y keen on this. 

The use case is simple - ask people to log time on issues in JIRA, then you want to use that data = fetch from Jira to Google Sheets to be able to analyse stuff. E.g. Which issues were worked on during last month by whom and what did they do?

Without support for exporting data there is little use for capturing it in the beginning.

Best regards,

Henrik

CTO clipsource.com, Sweden

PS. "Currently you can only query issue data" - what are work logs if not issue data?