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.
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)
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.
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.
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
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.
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.
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.