Appearance of generated document from multiple responses
When selecting multiple items (check boxes) and the document is generated, can you separate individual responses with spaces without commas so that it flows better as a paragraph or list of statements
This has since been solved!
- - - WORKAROUND - - -
It is very simple, actually - - -> Use the SPLIT function.
1) Go to the first empty column of your Form Response Sheet.
Example = Col E
2) In the first row (E1) put the following function:
where A1 is the column where the responses of your checkbox are recorded.
3) Now you will have the content of cell A1 divided in various cells.
The number of cells depends on the number of options checked by the user in his response. Now you can also create bullet points!
4) You can then combine these cells again.
Example =B1&” “&C1” “&D1 will add a space and a coma between the cells.