Hot answers tagged

1

The form will always record responses to separate questions in separate columns. But you can add a column with a formula that joins them together. For example, if you enter =join(", ", B2:K2) in cell L2 and drag down the column, the column L will have the data from columns B-K, separated by commas for readability. A more complex example is =B2&" ...


1

Short answer The link points to a Q&A that has two answers but non-of them looks to me to be appropiate. I.E. the code of one of answers is incomplete and both of them send emails, so the adoption is too complex to be used as a starting point. Below is a script that is easier to adopt. Instructions Create a test form and set it to send responses to ...



Only top voted, non community-wiki answers of a minimum length are eligible