=QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/BLAH BLAH BLAH","Comprehensive publishing calendar!B:AK"),"where Col35='x'"), Thank you very much in advance for your help!! Feel free to visit the help page for more details. I have that sheet connected to another sheet. Click the browser URL bar and copy the link to this file right till the hash sign (#): Note. ; To make a class last, click To end. Linking Google Sites and Google Classroom | Class Website - YouTube I use a pair of single quotes to indicate the non-blanks. How to Combine PowerPoint Presentations - How-To Geek They contain the names of all employees who became best in their jobs in different months. Could that be why it is difficult to work with that many records? It is described in this part of the article above, feel free to check it out. =QUERY({'Spring 2019'!A2:D7;'Summer 2019'!A2:D7},"select * where Col1 ''") If there are spaces in your sheet name, you must wrap it in single quotes like this: This immediately replicates whatever lies in that cell: Note. Once you share the file, just confirm by replying here. As a result, you will have a column with mixed data: numbers and text. Hi Natalia, Google employees label AI chatbot Bard 'worse than useless' and 'a As per your advice, I create a status column for each user sheet so the user can change or update the status of the project. I want to Fill those 12 cells with the Groceries total on the January tab, the February tab, March tab etc. Hi Natalia, How to merge multiple Google calendars into one - Tackle "select Col4, Col11 where Col4 is not null"). "url": "https://www.ablebits.com" I'm sorry, I don't have access to your spreadsheet.