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?
Best answer by LizView original
@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.
Hi, when it sends these answers all in one cell, is it possible to have the seperater to be something else than a comma?
@Designity We don’t have this available, but what kind of separator would you prefer? I can share the feedback to product.