# Syncing glide with google sheet **URL:** \ **Category:** Ask for Help\ **Created:** [February 21, 2024, 5:45pm UTC](https://community.glideapps.com/t/syncing-glide-with-google-sheet/71028 "2024-02-21T17:45:08Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Post date:** [February 21, 2024, 5:45pm UTC](https://community.glideapps.com/t/syncing-glide-with-google-sheet/71028/1 "2024-02-21T17:45:08Z")
I have set up two search pages with a specific search and it works fine. I added in the google sheet a [=counta(X:X) formula and it gives me, for example for cities the total cities which is 77 and not the count for the specific search. What could be the problem. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 21, 2024, 5:50pm UTC](https://community.glideapps.com/t/syncing-glide-with-google-sheet/71028/2 "2024-02-21T17:50:43Z")
How is your search set upm Is it a native Glide search, or did you create your own? I wouldn’t use a Google sheet formula when you could use a Rollup column instead. For it to work though, you would need to create your own search functionality which would involve a text entry component writing to a user specific column, followed by a Query column to find matching rows based on the search value, and finally a Rollup column to count the number of rows in the Query. ---
**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Post date:** [February 21, 2024, 6:02pm UTC](https://community.glideapps.com/t/syncing-glide-with-google-sheet/71028/3 "2024-02-21T18:02:48Z")
I created my own. I created a page for gender and city and the cities and gender drop down for me to select. ---
**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Post date:** [February 21, 2024, 6:04pm UTC](https://community.glideapps.com/t/syncing-glide-with-google-sheet/71028/4 "2024-02-21T18:04:58Z")
The dropdown is my filter for city and gender ---
**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Post date:** [February 21, 2024, 6:10pm UTC](https://community.glideapps.com/t/syncing-glide-with-google-sheet/71028/5 "2024-02-21T18:10:22Z")
I am using the Search function. Sorry for this ---
**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Post date:** [February 21, 2024, 7:22pm UTC](https://community.glideapps.com/t/syncing-glide-with-google-sheet/71028/6 "2024-02-21T19:22:00Z")
My pages ![Glide Count#1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/f/cf9633dfa3745c535c4f5ed8fe7261d0c5c76406.png) ![Glide Count#2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/1/f1ba78f58b0b64e255475d38dc731707cb7516f7.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 22, 2024, 12:17am UTC](https://community.glideapps.com/t/syncing-glide-with-google-sheet/71028/7 "2024-02-22T00:17:46Z")
If by “search”, you mean the filter you’re showing in the screenshots above, then there’s nothing you can do about it since the filter data isn’t available for you to rollup. > [@eyes Multiple Custom Filters in Glide Pages (How to)](https://community.glideapps.com/t/multiple-custom-filters-in-glide-pages-how-to/53035): > > How to Add Multiple Custom Filters to Glide Pages 0:00 How to Filter Collections & Lists in Glide 2:25 How to Add Custom Filters in Glide 7:25 How to Add a Custom Search Box in Glide [[How to Add Custom Filters to @glideapps Pages] ](https://www.youtube.com/watch?v=6C5pfmEzb8o) Also bookmark it in Glide University point_down You would have to build a custom filter like this. ---
**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Post date:** [February 22, 2024, 2:11am UTC](https://community.glideapps.com/t/syncing-glide-with-google-sheet/71028/8 "2024-02-22T02:11:22Z")
Thanks. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 22, 2024, 6:26am UTC](https://community.glideapps.com/t/syncing-glide-with-google-sheet/71028/9 "2024-02-22T06:26:01Z")
> [@Benjamin\_Strickland](#): > > I added in the google sheet a [=counta(X:X) formula and it gives me, for example for cities the total cities which is 77 and not the count for the specific search. I might be misunderstanding what you wrote here, but just to be clear - the Google Sheet has no awareness of any filtering that you may be applying in Glide. So any Google Sheet formulas will always give you a result based on the total number number of rows present in the sheet, regardless of anything that you do in Glide. As others have suggested, this sort of thing is much better done using Queries and Rollups in the Glide Data Editor. ---
**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Post date:** [February 22, 2024, 11:11am UTC](https://community.glideapps.com/t/syncing-glide-with-google-sheet/71028/10 "2024-02-22T11:11:11Z")
I tried the query and rollup but I do not think this type of search will work in Glide. It will give me the total, for example, cities, but I could not produce a total for each city produced in the search. When there are multiple cities to total Glide does not either. Thanks ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 22, 2024, 11:25am UTC](https://community.glideapps.com/t/syncing-glide-with-google-sheet/71028/11 "2024-02-22T11:25:21Z")
It’s possible. It’s just a matter of constructing the queries, relations and rollups correctly. I don’t know what your data looks like, but the simplest example is as follows: - Create a multiple relation column that matches each city name with itself. - Add a rollup column, target it at your multiple relation column, and take a sum of whichever column value you are interested. The above will give you a sum per city (assuming the target column is a number type - of course, you cannot sum a text type column). However, as was pointed out earlier, none of the above will work with the native filtering in Glide. If you want dynamic aggregations based on user specific filtering, then you must create your own filters. See below: > [@ThinhDinh](#): > > If by “search”, you mean the filter you’re showing in the screenshots above, then there’s nothing you can do about it since the filter data isn’t available for you to rollup. > > > [@](#): > > > > How to Add Multiple Custom Filters to Glide Pages 0:00 How to Filter Collections & Lists in Glide 2:25 How to Add Custom Filters in Glide 7:25 How to Add a Custom Search Box in Glide [[How to Add Custom Filters to @glideapps Pages] ](https://www.youtube.com/watch?v=6C5pfmEzb8o) Also bookmark it in Glide University point\_down > > You would have to build a custom filter like this. ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [February 22, 2024, 11:53am UTC](https://community.glideapps.com/t/syncing-glide-with-google-sheet/71028/12 "2024-02-22T11:53:40Z")
Hi Benjamin 👋 Are you familiar with Darren H.'s video where he [demonstrates filtering with choice components and date pickers to create sums and averages](https://www.loom.com/share/6757b08e64604463a7b1c4e8c4f37841) (rollups) using a helper table, user-specific columns and a query column? This combo is powerful. ---
**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Post date:** [February 22, 2024, 12:15pm UTC](https://community.glideapps.com/t/syncing-glide-with-google-sheet/71028/13 "2024-02-22T12:15:34Z")
I watched it but on my computer, his voice was slightly distorted in an attempt to understand what he was saying. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 22, 2024, 2:33pm UTC](https://community.glideapps.com/t/syncing-glide-with-google-sheet/71028/14 "2024-02-22T14:33:27Z")
There’s a transcript on the right of the window, I think it’s pretty well transcribed. ---
**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Post date:** [February 22, 2024, 2:58pm UTC](https://community.glideapps.com/t/syncing-glide-with-google-sheet/71028/15 "2024-02-22T14:58:14Z")
Ok. I will look at it again. Thanks