Glide putting ' symbol in values

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

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.

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

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

yes, and in the google sheet too.

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

i will try today.

1 Like