I have a template form and matching spreadsheet that need to be copied multiple times. When I make copies of the two, the copies are not linked for the form responses to go to the newly copied spreadsheet. The template spreadsheet is heavily formatted, so I don't want to create a new form response sheet in that existing spreadsheet (I know it gives you that option.). Any ideas?
Google-sheets – Google Spreadsheet Form Responses in to an already made sheet
google sheetsgoogle-appsgoogle-forms
Related Topic
- Google-sheets – How to get new Google Form responses to take on non-form functions in Google Sheets
- Google-sheets – Link Google Form responses To Already Existing Google Spreadsheet Tab
- Google-sheets – Importing data into Google Form response sheet with date, list, grid
- Google-sheets – Have a new Google form be started linked to an existing spreadsheet
- Google-sheets – copy a google form retaining responses and summary charts
Best Answer
If you do not want to create a new "form responses", make a copy of the forms (Not the response sheet). In the copied form, Change the response sheet to the one with all the formatting by going to:Menu>Responses> Change responses destination