Community
I would like to compile multiple different selected checkboxes that are spread across multiple different fields throughout the form, into a single field, saying some thing like "your selections are, [their selections]". how would I do that?
Comments (3)
May 18
You can use the + operator to concatenate text values. If you would like to concatenate the answers from three checkbox questions, add a paragraph question to your form and enter the formula Field1 + Field2 + Field3 in the Calculate option to combine the answers from those fields. Please note that you must type @ and select each required field from the list when adding the formula.
May 20
That works great, thanks, but after each of the selected options, there is no space. There is a comma, but it lists all the selected options without a space. How would I fix that?
May 21
The selected answer choices in a checkboxes in a question will be separated by a comma. This is the standard format in which Google Forms record the responses and it cannot be changed.
Add your comment
Add photo