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, 2019 at 10:05

1 Answer 1



"Form Responses!a2:M100"


"Form Responses!a2:M"


Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.