Skip to main content

When exporting a ticket to Sheets, the numbers are exported as text instead of numbers

Feature Request

When I export the tickets to Sheets to analyze the data, the numbers are converted to text, which prevents me from using formulas and performing calculations. I know I can create new columns and start editing them, but that wastes my time… How can I make sure that when I export numbers, they’re exported as numbers and not as text????

Posted by Jaime Concha Jaime Concha ·
2 comments

Log in to comment and vote

Comments2

  • Diego Chahuan Diego Chahuan

    •

    May 15

    Hola, no esta en el roadmpa de corto plazo pero dejo unas formulas de excel que te pueden ayudar con esto.

    =VALUE(A1)
     =A1*1 
    =--A1 
    =NUMBERVALUE(A1, ",", ".") 
    =VALUE(TRIM(CLEAN(A1)))

  • Jaime Concha Jaime Concha

    •

    May 15