'Why is my function in Google Sheet not working?
I have a spreadsheet with registrations for a Summer Camp. I want to filter the registrations based on location, in a new spreadsheet.
I have used the following code: =QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1BDv-P3Bx8kHLSEUILmFBMmSB502-LUkQ8oiw8BYaPyo/","Inschrijvingen!A2:W2800"),"SELECT * WHERE Col1 contains 'Amersfoort - Groep 1-2'")
It keeps on saying: error.
The second image is the main file with all registrations.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|