concatenation – Using CONCATENATE with Google forms and sheets

concatenation – Using CONCATENATE with Google forms and sheets

ArrayFormula(A2:A & B2:B) should do the trick.
Note that the formula will persist even if you put it directly at the end of the form and then add a new field.
It will just be shifted to the right, so you dont need to worry about taking care of that when you modify your form.

The CONCATENATE function is a Google spreadsheet function that combines two or more text strings into a single string. It appears in the dropdown menu for functions above cell A1, and when you select it, it places an =CONCATENATE()= formula in the selected cell.
Note that you may need to replace spaces with & if your text has spaces.
In order to perform this operation on Google Forms though, you will need to set up Form Embeds by making sure you have the input type of google form embed. When embedded forms are enabled, there is no need for individual cells within a google sheet workbook with custom formulas next to each question result button as theyre all being calculated.

You can find more info on CONCATENATE by referring to this.

concatenation – Using CONCATENATE with Google forms and sheets

Leave a Reply

Your email address will not be published. Required fields are marked *