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.
Best answer by john.desborough
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
+5Hi
+6
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
