-
killkoAsked 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?
-
jonathanReplied 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.
Please share to us the URL of your form that have the issue so we can also check on the form itself.