Filter Google Spreadsheet Data to other Google Sheets

If you use Google Forms a lot but hate having to continually filter the main Google Sheet, you are in luck. Learn how to filter your Google Sheets to that you can look at data based on the criteria you set.

[@user-hi4ii6si6e]

This is an excellent video! Showed me exactly how to do the data filter that I needed. Thank you for providing a clear, easy to follow tutorial! 🙂

[@JasonWong-jm1ql]

I found that you have to enclose the tab in single quotes for sheets to recognize the dataset. Received an "unable to parse" error otherwise. Hopefully others might find this useful. e.g. =query('Database'A:S, ....etc)

[@marqell099]

This is great. Thank YOU!
Is there a way to for =query to retain formats, formulas and colors?

[@philipoamiola]

Thank you for the excellent tutorial. I have successfully used it to filter for desired categories. However, when I try to filter for date range, the query only returns the header row without any other data. Here's the formula I used: =query(Database!A:M, "select * where G > date '2023-10-31' and G < '2023-12-01'") to filter for November 2023 in the database.
I have also tried to use a modified version of the category filter (something like =query(Database!A:M, "select * where G Contains 'Nov'") but the result is the same; query only returns the header row.
Please could you possibly help to point out what the issue might be?
Thank you for your kind assistance.

[@salam2701]

This video is very helpful thank u

[@cottentechcoach]

You’re welcome.

[@shishiranjelorozario9340]

Excellent video. But my one is not working. The formula is okay but only heading raw is showing, not the other information where containing dates. Please help me.

[@janskice]

How did the column titles appear on the query sheets when they did not include the search criteria?

[@cottentechcoach]

Honestly, I have no good answer to this... they just automatically show up. 🤷‍♀️

[@jayantakhamrui4216]

hay I have a question about can i ask?

[@laurenbarta761]

Is there a way to sort the Grade 8 sheet by last name column A-Z?

[@cottentechcoach]

Yes. You'll highlight the column you want to sort by... in this case it is the Last Name column. Go to Data > Sort Sheet > By Column E (A to Z)... and of course 'E' is in reference to the column you highlighted. I hope this helps. Let me know if you have any more questions.

[@napyful]

Is there any way that if I fill colour to a row, say green, and the whole row gets copied to another sheet? Please reply if this is possible, it will be very helpful.

[@cottentechcoach]

Does this mean you want to keep the color when you copy the whole row to another sheet?

[@johnlimbaring4781]

How about if you need to pull 2 data in 1 column? For example you want to combine both grade 8 and 9 in one sheet. Thank you in advance!

[@cottentechcoach]

If your using query to combine 8 and 9 into one sheet and they are from the same original spreadsheet (like the one in my video), here is the formula I would use: =query(Database!A:L,"select * where (J>=8 and J

[@amandamohammed1096]

@@cottentechcoach I cannot get this to work :(

[@cottentechcoach]

What are you trying to do?

[@yulbontia4986]

What about you edit for example on grade 8 sheet and will also change the database?

[@cottentechcoach]

If I'm understanding your question correctly....
Editing on the different sheets where the data is pulling in from the database will not edit the database. If you edit anything on the database, the edit does pull through on the Sheet that includes that data in the query formula.

[@moniqueacevedo2232]

What about if you need to get data from 2 columns?

[@cottentechcoach]

You would use the "select" function. =query(DataRange!,"select A, D, E where..."

[@smkrapatsetiakpm-sk-admin8280]

how about 2 column data filter?

[@cottentechcoach]

Can you be any more specific about what you are trying to do?