The form calculated value appears as TEXT data type in google spreadsheet

  • killko
    Asked on October 5, 2018 at 4:06 PM

    I used calculated fields, and the linked m form to Google Sheets. When the result is positive a number appears in a Sheet cell, but when the result is negative a TEXT() is created instead (ie. =TEXT("-98.95","0")). Why, this makes calculations in Google Sheets difficult without reformatting?

  • jonathan
    Replied on October 5, 2018 at 7:18 PM

    It could be the calculated data result is in text data type and not numeric.

    You can distinguish the difference in the calculation formula.

    Text type is colored brown and has A-Z suffix.

    Numeric type is colored black and has 1-9 suffix.

    1538781453zzz 2018 10 06 07 Screenshot 10


    Please share to us the URL of your form that have the issue so we can also check on the form itself.