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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.