Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Custom fields start with a quote

Antoine Pastor
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!
January 16, 2023

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

1 answer

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 16, 2023

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.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events