# Is there some sort of equivalent to a =query ...

(Steven Jeffery) #1

Is there some sort of equivalent to a =query type calculation in google sheets, in app sheet?

I want to find the total qnty of similiar filter sizes on various equipment.

@Steven_Jeffery I don’t think there’s a way to do exactly what you want.

In your AC table, is “filters” a column with value like “20x20x2” and a “qnty” column? If so, you could create a table view of your AC table, group by “filters” column, with group aggregate COUNT. Set the position to Ref and it should show up as the inline view of AC units for a particular company.

(Steven Jeffery) #3

So how would I do the following:

I have a site: ABC Company

ABC Company has these units:

AC#1 - filters 20x20x2 qnty:2 AC#2 - filters 20x20x2 qnty:1 AC#3 - filters 30x25x2 qnty:2 AC#4 - filters 30x25x2 qnty:1

I want to have a summary column, or summary page that reads:

20x20x2 = 3 30X25x2 = 3

For the site I decide to look at.

(Levent KULAÇOĞLU) #4

@Steven_Jeffery Depending on what you try to achieve, SELECT expression/function is what you are looking for.