# Not getting option to roll up on query column when google sheet is linked

**URL:** <https://community.glideapps.com/t/not-getting-option-to-roll-up-on-query-column-when-google-sheet-is-linked/70232>\
**Category:** Ask for Help\
**Created:** [January 30, 2024, 4:09am UTC](https://community.glideapps.com/t/not-getting-option-to-roll-up-on-query-column-when-google-sheet-is-linked/70232 "2024-01-30T04:09:25Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [January 30, 2024, 4:09am UTC](https://community.glideapps.com/t/not-getting-option-to-roll-up-on-query-column-when-google-sheet-is-linked/70232/1 "2024-01-30T04:09:25Z")

</div>

Hey Guys,

I have linked a google sheet to my glide app, I did a query to get the related data from google sheet. I am trying to do a roll up of the Query column but it is not giving me the option to select the query column for roll up source.

Is there any restriction like this when it comes to google sheets?

openedQuery is my query column. as shown in screenshot below

 ![Screenshot 2024-01-30 at 9.38.03 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/8/980da089717b9753b9c2b0e3041e7cdbe034fe78.jpeg)  
Thank you guys in advance for the help.

---

<div class="post-metadata">

**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:** [January 30, 2024, 4:16am UTC](https://community.glideapps.com/t/not-getting-option-to-roll-up-on-query-column-when-google-sheet-is-linked/70232/2 "2024-01-30T04:16:43Z")

</div>

You need to select the Query column directly, rather than via the sheet. You can see it there in your screenshot, at the top of the list.

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [January 30, 2024, 4:34am UTC](https://community.glideapps.com/t/not-getting-option-to-roll-up-on-query-column-when-google-sheet-is-linked/70232/3 "2024-01-30T04:34:30Z")

</div>

Thank you @Darren_Murphy I was just about to comment saying I could do that.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [February 6, 2024, 4:34am UTC](https://community.glideapps.com/t/not-getting-option-to-roll-up-on-query-column-when-google-sheet-is-linked/70232/4 "2024-02-06T04:34:46Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.