Multiple Choice Reporting | Community
Skip to main content
Answered

Multiple Choice Reporting

A

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

Best answer by Liz

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. 

View original

4 replies

Liz
Community Team
Forum|alt.badge.img+5
  • Liz
  • Tech Community Advocate
  • 15028 replies
  • Answer
  • January 25, 2023

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. 

Life is a series of awkward moments separated by snacks.
A
  • Alan King
  • Author
  • Explorer
  • 1 reply
  • January 30, 2023

Thanks Liz!

D
  • Designity
  • Navigating the Land
  • 1 reply
  • March 21, 2023

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

Liz
Community Team
Forum|alt.badge.img+5
  • Liz
  • Tech Community Advocate
  • 15028 replies
  • March 21, 2023

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

Life is a series of awkward moments separated by snacks.

Reply


Still need help?

Don't be shy and ask the community.

Ask your question here!
Community T&Cs