Google-sheets – Moving Rows of Google Form Responses to a new Sheet based on a specific answer in a column

formulasgoogle sheetsgoogle-sheets-query

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?

Best Answer

Replace

"Form Responses!a2:M100"

by

"Form Responses!a2:M"

Related