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?