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,
find the Response Sheet for the first Form, Select and for this to work.