# Request: Specify a cellRange for a Google Sheet

**URL:** <https://community.glideapps.com/t/request-specify-a-cellrange-for-a-google-sheet/15851>\
**Category:** Feature Requests\
**Created:** [September 15, 2020, 8:30pm UTC](https://community.glideapps.com/t/request-specify-a-cellrange-for-a-google-sheet/15851 "2020-09-15T20:30:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Stewart\_Whaley](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stewart_whaley/32/13633_2.png) [@Stewart\_Whaley](https://community.glideapps.com/u/Stewart_Whaley)\
**Post date:** [September 15, 2020, 8:30pm UTC](https://community.glideapps.com/t/request-specify-a-cellrange-for-a-google-sheet/15851/1 "2020-09-15T20:30:18Z")

</div>

Allow me to specify the cell range I want to use per Goolge Tab/Sheet. The example being I have calculated columns values (eg: subTotals, Totals, etc. [at the bottom]) that I don’t want as part of the rows going into Glide. Currently I specify the name of the Tab in GoogleSheets, I’d like to also specify the dataRange.

---

<div class="post-metadata">

**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:** [September 16, 2020, 12:31am UTC](https://community.glideapps.com/t/request-specify-a-cellrange-for-a-google-sheet/15851/2 "2020-09-16T00:31:03Z")

</div>

Is it just for easier management of data or do you have another use case?

---

<div class="post-metadata">

**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:** [September 17, 2020, 2:54am UTC](https://community.glideapps.com/t/request-specify-a-cellrange-for-a-google-sheet/15851/3 "2020-09-17T02:54:27Z")

</div>

You can always set a filter in glide to only show rows that don’t have ‘Total’ as part of one of the column values. This will ignore the totals.

Or if that app will never be able to edit the rows, you could use a formula in google sheets to copy a certain cell range to another sheet. Then use that sheet in your app.