I have a Google Form, the answers go to Google Sheets.
I want to import answers from sheets (Аnswer) into new sheets but with a filter applied.
For example: from sheets (answer) into a new table, I import answers only from 100 REPPM. For this I use the following formula:
=QUERY(IMPORTRANGE ("https://docs.google.com/spreadsheets/d/1dMo6F1CTxAaEx1bS2NEu4kIu5hJTCBbCt13AV2E_f2w/edit#gid=1390527531","Answer 1!A:E"),"Select Col1,Col2,Col3,Col4,Col5 Where Col2 Matches '"&100 REPPM&"'")
My formula is incorrect, please help.