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.
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?
i will try today.