Query group by....inside Glide?

[Jeff_Hager]

Add Query function to Glide Tables, Please!

Just want to add to this…if you need a workaround for now…what I would do is first make sure you have enabled the RowID column in your sheet. Then create a template with the unique key values you would normally select for a query. Then create a multiple relation that links that template back to itself. Then create a Single Value column to get the first RowID out of that relation. Then create an IF/Then column that returns ‘true’ if the row’s RowID matches the single value RowID. Finally create…