Google Spreadsheet: negative entries in short text entry and number fields are incorrectly formatted

  • Profile Image
    shoefactorybelleville
    Asked on July 24, 2018 at 11:40 AM

    Greetings,


    When I use the google sheets integration any negative numbers from the form to the google sheet are formatted at text with parenthesis such as

     =TEXT("-1.39","0")

    As such this is throwing off calculations

    Thank y0ou

    Mike


  • Profile Image
    Welvin
    Answered on July 24, 2018 at 01:16 PM

    I was able to reproduce this problem using a test form. I have also troubleshot this by adding a short text entry field, but the result is the same. 

    I've created a ticket on this thread and submitted it to our backend team for resolution. If we have an update, we will let you know here.