Enum dropdown in Form populates a " ' "

[Bishop]

I have an Enum dropdown set-up that allows me to put in a number between 1 - 100

When I put my entry in, it populates in my app just fine. Let’s say I put in “8”

I go check the data in Gsheets, and the entry is " '8 "

Which of course won’t work to do formulas. Does anyone know how to fix this?

[Suvrutt_Gurjar · Accepted solution]

Please try to have the base type of the enum column as “Number” and in the Gsheet please format the corresponding column as 'Number"

[Bishop]

Hello. I have done so, but still, the numbers I put into my Form show up like this in the Gsheet.

[Bishop]

I figured it out. Thank you.

[Suvrutt_Gurjar]

Great. May we know how you solved it?

[Bishop]

It was exactly as you said but I hadn’t deleted the data from my app and re-added it, so the format changes to “Number” hadn’t taken place