I am sending this message since I need some help. I face a problem between Glide and Google sheets. To explain more my issue, I am using Stripe and I duplicated the App : Sales sheet to a separate sheet called Sales by using this formula ={‘App: Sales’!A:Z}
From glide, I did some relation and lookup in this separate sheet called Sales. However I cannot see the data in Google sheets.
I need these data for sending zaps with zapier. Is anyone may help me please ?
Or suggest me solutions ?
Glide columns, such as relation, lookup, math, template, etc. Will not be visible in a google sheet. They are columns that are calculated on the fly, and actually are calculated on each individual user’s device. They are not columns of data in the traditional sense. What you see in those columns is being calculated in real time.
Those values are not stored anywhere, and because of that, none of the values from those glide computed columns will appear in a google sheet.
What is being mentioned in the previous posts is that you need to create separate formulas in your Google sheets if you need those same values in your Google sheet
Sure I got it thanks @Jeff_Hager@ThinhDinh !
I am trying to use vlookup to retrieve data from a sheets but I need some help for the syntax of formula.
I put an example of my google sheets. In my case I would like to display
Vendor, Price, TAX, Commission, Price final in App : Sales sheets from Products sheet. In both sheets I have ID product to do the link. Letting you know my data come at the end of the sheets.
It has been done for you. The arrayformula takes the product ID in column D, looks to the Products sheet and returns column D, E, F, G through a temporary data table containing columns N, D, E, F, G of the Products sheet.
Thanks @ThinhDinh for your quick help !
just to understand what does that mean {2\3\4\5} ?
Also do you know why when there are a formula in the sheet, the rows come at the end of the sheets after been added from glide ? Could you please tell how the rows can come at the beginning ?
The temporary data table goes N, D, E, F, G. I want to return D, E, F, G and their order is 2nd, 3rd, 4th, 5th.
When you use arrayformulas, you must delete all empty rows, because weirdly the Google API doesn’t see those as empty rows and writes the new rows at the end of the Sheet.
