How to fix seeing [no field found] under custom field after using open in google sheets feature?

[Deniz Ocak]

Hello,

This issue started to happen recently, it was working well before.

We've created a custom field like "Priority points (0~1000)[Number]", we use it without any problem and we also could see the number values under that field after using "open in google sheets" feature. 

But recently it started to show [no field found] text instead of number value. It doesn't matter if the field is empty or not.

But when I export the issues to the excel (office), I can see the values.

How can we fix seeing the [no field found] text while exporting (open in google sheets) to the sheets?

Thank you.

[Deniz Ocak · Accepted solution]

The screenshot:

[pavel_pejsek]

Hi. I have the same problem but i use "Open in Microsoft Excel".
  

[pavel_pejsek]

So. I try it now and works fine. Works with both plugin.  

[Deniz Ocak]

Hi, I checked it and saw that it's fixed on my side, too. 

[Aman Khare]

What was the fix to this issue? I am facing the similar issue on both MS Excel and Google Sheet.

[Jon Irusta]

We are facing the same problem, any idea about how could it be solved? 

Thanks in advance! 

[Stien Creyf]

Same problem here! Can anyone provide a solution? 

[Wade Sherfick]

Same issue.  In Excel, lists customfield_10066 as the Header and [no field found] in all data fields.  

[Csaba Vertessy]

Having the same issue.

Why is this marked as Answered? No solution nor workaround has been provided.

[Marco Müller]

Same Problem. There is no answer provided here!

[Dustin Tanner]

I had this same issue and was able to resolve by using the Jira Cloud for Excel within Excel Desktop. If you go to the "Fields" tab, my field did not show as selected even though it was exported from Jira and was showing [no field found] originally. I edited the fields and found the missing one, clicked on Get Data, and then I had all of the data I was missing for that column.

I do not know how or why this happened as I have been exporting this data for over a year now with no issue and it just happened today for the first time. But hope this solution can help others with a similar challenge.

Your JQL query should have exported from Jira when you opened Excel but if not, you can just copy and paste into excel if needed.