Problem with Jira Cloud for Sheets

[Nadjeb]

Good Morning 

This is my first question in this community !

I'm trying to setup a dynamic google sheet integrated with jira cloud for google sheet

I have problem when I try to use =jira() my jql query contains reporter in membersof 

=jira("project = ITS AND reporter in (membersOf("Group name")) AND resolutiondate > startOfWeek()") 

when I use the JQL function directly on jira cloud for sheet it works fine but when I use =jira() in the cell it doesn't work error message formula parse error 

Any help ideas thank you 

[John Funk]

Hi Nadjeb - Welcome to the Atlassian Community!

Does the JQL work okay if you just do the query in the advanced search? 

[Nadjeb]

Hello John,

Yes and now instead for =jira() I'm using directly the filters that I created on jira cloud