When I set values of enum to numbers such as 1 2 3 result in Google Sheet is '1 '2 '3 (there is an excess single quote symbol) but T1 T2 T3 is fine. Is this a bug? or I do something wrong?
Select the column in Google Sheets, then click Format>Number>Plain Text, and then add another value from AppSheet and see if that fixes it.
Canโt solve the problem Get the same result.
Hmmโฆ Iโm not sure what else could cause it but Iโve seen the sheet formatting do this.
Maybe the validation dropdown in the sheet is causing it. You can set the validation in AppSheet, so you donโt have to add it to each cell in the Google Sheet. Try removing validation from the sheet side, and use AppSheetโs Valid_If setting.
Still having the same problem regardless of whether changing to Valid_If or removing the data validation in the Google Sheet. Anyway, Thank you for the answers.
May I ask whatโs the real problem? What kinda harm youโre experiencing with your appโs flow with that apostrophe in the gSheet?
Thereโs nothing wrong here. Numbers formatted as text is distinguished with an apostrophe in the gSheet so that itโs treated as text, not number.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |