I have the following sheets:ListAListBListCNote: at each sheet I have a column which contains YES or NO.How do I query all my lists (spreadsheets) where myBooleanColumn equals to YES/NO?
Query multiple Google spreadsheets
google spreadsheets
Assuming that all your sheets are in the same spreadsheet and the range of interest is A:B where column B have values YES/NO and you want only the rows where B is equal to YES, then the following formula should work:=QUERY({ListA!A:B;ListB!A:B;ListC!A:B}, select Col1, Col2 where Col2='YES')ReferencesQUERY - Docs editors Help