NAN message in a field

[cbordolli]

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

[WillowMobileSys]

“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?

[cbordolli]

Hi, the current column type in appsheet is text also like in google sheets.
Thanks

[WillowMobileSys]

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.

[cbordolli]

both in appsheet and in google sheets the format is in text / text without format

Thanks, again

[Steve]

Does the corresponding column of the spreadsheet contain any formulas?

[cbordolli]

No, none of them. Thanks

[cbordolli · Accepted solution]

I already found the problem, it was marked as a number in a column. Thank you very much for your time. Greetings