Custom fields start with a quote

[Antoine Pastor]

Hello,

I'm using Jira Cloud for Sheets to import stuff from Jira, and it works great. 

However, for some fields (in my case, custom fields), the value is imported with a single quote at the beginning (eg. an integer 72 will be imported as '72) 

That causes many problems in the sheets, as I can't filter against that column anymore. 

I've tried to change the formatting of that column, which fixes the problem, unfortunately, as soon as the sheets refreshes for a new import, the formatting is overriden. 

Is there any way to get my values as a number in Google Sheets ? 

Thanks in advance

[Nic Brough -Adaptavist-]

Welcome to the Atlassian Community!

What types of field are doing this?  I suspect you'll find they are text, not numbers, so sheets is importing them as text - it needs the ' to tell it the cell is a string.