Good, I have a field in a text type google form but my form shows me NAN (in that field I have numerical and text values), I canโt find why it happens.
Greetings
Solved! Go to Solution.
I already found the problem, it was marked as a number in a column. Thank you very much for your time. Greetings
โNaNโ refers to โNot a Numberโ. This typically happens when a column type is defined as numeric but the value it is trying to display is something other than numeric.
If you have a mix of numbers and text, the column MUST be defined as Text or similar type.
What is the current column type definition?
Hi, the current column type in appsheet is text also like in google sheets.
Thanks
Are there any โNaNโ text values in the Google sheet itself?
I think we need to see your column definition and the column data to help more.
both in appsheet and in google sheets the format is in text / text without format
Thanks, again
Does the corresponding column of the spreadsheet contain any formulas?
No, none of them. Thanks
I already found the problem, it was marked as a number in a column. Thank you very much for your time. Greetings
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |