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?
Solved! Go to 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"
Please try to have the base type of the enum column as “Number” and in the Gsheet please format the corresponding column as 'Number"
Hello. I have done so, but still, the numbers I put into my Form show up like this in the Gsheet.
I figured it out. Thank you.
Great. May we know how you solved it?
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
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |