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

[Dilip_Adiga]

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

Thank you guys in advance for the help.

[Darren_Murphy]

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.

[Dilip_Adiga]

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