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.