1 Form - 2 Sheets
Options
Jaime Ciabattoni
✭✭✭✭✭
Hi there,
Curious if anyone has had this and if it's possible. I'd like to create a single form but based on the answer to one question have the information go to one of 2 different sheets.
Thanks! ~Jaime
Tags:
Best Answer
-
You would have the form populate the same sheet for all entries and then set up a Move Row automation to be triggered when a row is added and that particular answer is the one you want on the other sheet.
Answers
-
You would have the form populate the same sheet for all entries and then set up a Move Row automation to be triggered when a row is added and that particular answer is the one you want on the other sheet.
-
Thank you @Paul Newcome! Great idea.
-
Happy to help. 👍️