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?
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