1 Form - 2 Sheets

Jaime Elizabeth

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

Paul Newcome

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.

Paul Newcome

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.

Jaime Elizabeth

Thank you @Paul Newcome! Great idea.

Paul Newcome

Happy to help. 👍️