Answered

Apostrophe being added to Google sheets responses

  • 26 June 2023
  • 2 replies
  • 261 views

I’m using the Matrix question type where users will select “True” or “False to a series of questions. The True and False responses come through to my Google Sheet with an apostrophe in front of them (‘TRUE and ‘FALSE).

Is there a way to prevent that from happening? I’m using a formula to count the number of TRUE responses vs the number of FALSE responses and the apostrophe is throwing off my results. Find and Replace isn’t working to try to get rid of the apostrophe. 

icon

Best answer by john.desborough 26 June 2023, 21:53

View original

2 replies

Userlevel 7
Badge +5

Hi @laurakotsiovos This is a great question. Is the formula in the same sheet that the results are being sent to? 

Userlevel 7
Badge +6

@laurakotsiovos @Liz 

 

couple of things from sheets - True is a google sheets function. if you use true and false as column headers in a matrix, google sheets throughs the apostrophe in there to denote that this is ‘text’ and not a function/value … 

other text choices, like “poor” in my image below show that there is no apostrophe

 

des

Reply