Glide putting ' symbol in values

Ask for Help
1

in text entry, if i put a number in the google sheet, the value have a ’ symbol before, ex: '30, my formulas cant work with this

2

What if you use a number entry instead? If numbers are entered into a text entry, it will be saved as text, meaning the ’ character is added so the google sheet recognizes numbers as text instead of numbers.

3

i tried now, dont work too, always put a quotation mark before the number ;(

image
image840×577 28.9 KB

4

imagem_2022-05-09_131538921
imagem_2022-05-09_131538921717×587 72.1 KB

5

Is your column type set to numeric in the glide data editor?

6

yes, and in the google sheet too.
image

7

What if you start them from scratch, creating two new columns, set it to “number” in the Glide editor and then try writing to it using number entries like you do here?

1 Like
8

i will try today.

1 Like