How do you link a Form to a specific sheet?
I have created Form A and Sheet A and Form B and Sheet B. I would like to point all submissions from Form B to Sheet A and then delete Form A, basically replacing Form A with Form B. In the end, all submissions from Form B will go to Sheet A.
Best Answer
-
Thank you! It would work and we had thought of that - the downside is the reports and links we have built on the rows will need to be recreated, which is a lot (at least that is our assumption). Still, knowing it can't be done saves me a lot of time in pursuing that. Thanks again!
Answers
-
Hi @SDPatton, There is no way to link a form from one sheet to another however you can use an automation in your Sheet B to move or copy the row to Sheet A when ever a row is added (a form submission). Would that work?
-
Thank you! It would work and we had thought of that - the downside is the reports and links we have built on the rows will need to be recreated, which is a lot (at least that is our assumption). Still, knowing it can't be done saves me a lot of time in pursuing that. Thanks again!
