Answered

Multiple Choice Reporting

  • 25 January 2023
  • 4 replies
  • 57 views

I have ran a multiple choice question and allowed respondents to tick all that apply.

When I get the results into Google Sheets; all answers are listed in a single cell separated by a comma. 

This means I cannot count the values of all that apply unless I manually separate the answers. 

Can anyone help me fix this issue?

Many thanks,

Alan

icon

Best answer by Liz 25 January 2023, 21:44

View original

4 replies

Userlevel 7
Badge +5

Hi @Alan King Thanks for stopping by the community. This is expected behavior of our Google Sheets integration when you have multiple selection turned on. You would need to create a formula to separate the data if you would like it in different cells. 

Thanks Liz!

Hi, when it sends these answers all in one cell, is it possible to have the seperater to be something else than a comma?

Userlevel 7
Badge +5

Hi @Designity We don’t have this available, but what kind of separator would you prefer? I can share the feedback to product. 

Reply