I have four surveys (google forms) from which I want responses to go to a single response spreadsheet (each on a different sheet). It appears in the form view that I can select to have the response go to a new sheet in an existing spreadsheet, but when I select that option on the second form, I get a message saying that the spreadsheet is already in use. How do I get this feature to work properly? I want all the pre- and post- survey data in one single spreadsheet!!
Maybe this has changed in new Google Sheets because in the second and subsequent Forms it seems possible to select Responses,
Choose response destination:
New sheet in an existing spreadsheet..., Choose:
find the Response Sheet for the first Form, Select and for this to work.