Skip to main content
Answered

Removing the ' from a number during Google Sheets Integration


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?

Best answer by servz

@Liz , Changing the question to a number response only worked perfectly. Thanks for asking that question!

View original

5 replies

Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 14571 replies
  • August 29, 2022

Hi @servz Happy Monday! Do you mind sharing more about how you have that field in the form set up (ex, what kind of question block it is) and a screenshot of the Google Sheet? 

Thanks in advance!


Gabi Amaral
Ex–Typefomer
Forum|alt.badge.img+5
  • Ex–Typefomer
  • 1779 replies
  • September 5, 2022

Hello @servz! How are you doing today?

I was wondering if you were able to check Liz' reply to your question? Make sure to share your form set up and a screenshot of your google sheet! 

Hope you have a great week! 


  • Author
  • Explorer
  • 2 replies
  • September 5, 2022

Hi @Liz , Sorry we missed your response. Busy week. 


One question is a short text and another is multiple choice. My partner set it up, maybe a number question would work?

 

Screenshot:

​​​​​​


  • Author
  • Explorer
  • 2 replies
  • Answer
  • September 5, 2022

@Liz , Changing the question to a number response only worked perfectly. Thanks for asking that question!


Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 14571 replies
  • September 6, 2022

Glad to hear that worked, @servz ! Thanks for letting us know. 😁