I have a Google Sheet collecting responses from a Google Form. Based on answers in Column C (Col3), I would like the entire row imported to a completely different Google Sheet.

I figured out a formula that moves just the first row, but subsequent rows that are submitted in my form, meeting my criteria are not importing.

Here is the current formula:

=Query(IMPORTRANGE("1W9pMF4qrQMV5vMN9ST47HYyvpj0iT9ls9_KwZVwxV0Y", "Form Responses!a2:M100"),"select Col1,Col2,Col3,Col4 where Col4='BMS'",1)

What do I need to do to get this to continue adding data submitted in subsequent rows?

  • Welcome to WebApps StackExchange. How many rows of data do you get with just the IMPORTRANGE command? – Tedinoz Nov 8 at 10:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.