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

Deniz Ocak October 13, 2020

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.

4 answers

1 accepted

3 votes
Answer accepted
Deniz Ocak October 13, 2020

The screenshot:

nofield.jpg

pavel_pejsek October 13, 2020

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

pavel_pejsek October 13, 2020

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

Deniz Ocak October 13, 2020

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

Aman Khare
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 8, 2022

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

Like # people like this
Jon Irusta June 5, 2023

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

 

Thanks in advance! 

Stien Creyf
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 4, 2023

Same problem here! Can anyone provide a solution? 

Like # people like this
Wade Sherfick
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 6, 2023

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

Like Eve Seck likes this
5 votes
Csaba Vertessy
Contributor
January 12, 2024

Having the same issue.

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

1 vote
Marco Müller April 24, 2024

Same Problem. There is no answer provided here!

0 votes
Dustin Tanner
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 5, 2024

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.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events