We are using our typeform to send over data to google sheets, and run a formula per line in google sheets using Array Tables. The problem I am having, is Typeform is sending over the number with an apostrophe in front of it. I am assuming that is to protect leading 0s.
For example:
The number entered in typeform is 2600.
It shows up in Sheets as ‘2600.
The apostrophe breaks my formula. I need to remove that. I have tried presetting the cells and it still shows up. Any one have a solution?