Is there a way for a form to add data to two sheets

I want to be able to take the inputs from a form and create a new data row in two separate sheets.

You would need a script to do so, triggering an action to copy the values you need to the new sheet when a new row is added in the original one.

1 Like