This topic was inspired by our last community meetup, in which we talked about some formulas in Google Sheets and some people want to know more about QUERY, which was branded “The most powerful function in Google Sheets” by famous GSheets teacher Ben Collins. So, what is QUERY, and why is it so pow…

@Krivo @nathanaelb @Manan_Mehta @Naos_Wilbrink @Erni_D This was the post I promised to write after the community meetup, hopefully it would help you in many cases. There will be a part 2 in the upcoming days so stay tuned!

@ThinhDinh very, very nice work. You do really nice tutorials. Thanks for sharing.

My pleasure to help the community. Your posts are very nice as well! Have a nice Sunday yourself.

@ThinhDinh sorry to have missed the MeetUp! QQ I know how to use QUERY but I’m wondering, in the context of a Glide app, why/when would I use this? Or is this just for data cleaning of my spreadsheet (as you note above)?

I would imagine mostly data cleaning, but for some complex cases, for example this: [image] Multiple criteria sumif array formula with logic Ok I’m back with what seems to work. Firstly, ArrayFormula does not work with SUMIFS, or QUERY. It would have been such easier ta…

Thank you so much! I was struggling whit the logic behind this. Thanks to clarify in many ways! Awesome

Glad it may help people in various ways. Stay tuned for the next part :smile:

A few cases where I need to use query are the following: I dynamically build a sheet from a list of multiple lessons for students in a different sheet. A student can have multiple lessons from a coach within a specified date range, but I only only want to create one unique set of student/coach/d…

Point 1 is what I’m working now. Are you trying to create a past class sheet? And if so,you created one page for each student?

Yes, I have several levels deep. First a button to a page that lists all of the billing periods for a coach. [image] From there I list all of the billing periods for that coach: [image] Selecting a specific billing period leads me to the sheet that contains the queried information from the le…

Tutorial - QUERY: "The most powerful function" in Google Sheets (part 1)

Ask for Help

ThinhDinh June 21, 2020, 11:52pm 22

Thanks Nadir, you can check out part 2 here as well.

Topic		Replies	Views
Tutorial - QUERY: “The most powerful function” in Google Sheets (part 2) Ask for Help	9	1657	July 23, 2020
🙏😍 Add Query function to Glide Tables, Please! Feature Requests	26	2865	March 19, 2024
🧲 The QUERY Column: One Column to Rule Them All! Ask for Help	51	2447	September 12, 2023
Help with a google sheet query for a billing app Ask for Help	24	1619	May 22, 2020
Query user data on reviews form based on product sheet Ask for Help	24	1365	July 5, 2020

Tutorial - QUERY: "The most powerful function" in Google Sheets (part 1)

Related topics