CODEWITHSUNDEEP
google-sheetsfiltergoogle-sheets-formulagoogle-formsgoogle-sheets-query
Parth Parulekar
Parth Parulekar

Reputation: 107

Is it possible to continuously move Google Form Responses to another Sheet?

I have a Google Form that is accepting responses and filling them into a Google Sheet 1.

I want Sheet 2 in the same file to continuously grab responses in certain columns of Sheet 1 and import them into Sheet 2. This Sheet 2 will serve as a viewable spreadsheet, or a spreadsheet that my code is compatible with (reordered a certain way, different column names, colored).

What command/equation can I use in Sheet 2 ("move_here") to pull those columns from Sheet 1 ("responses")?

enter image description here

Upvotes: 1

Views: 906

Answers (1)

player0
player0

Reputation: 1

you can use:

={responses!A:Z}

or:

=FILTER(responses!A:Z; responses!A:A<>"")

or:

=QUERY(responses!A:Z; "select A,B,C,D"; 0)

or other 20+ possible formulae...

Upvotes: 1

Related Questions