Hello the Glide Community! :wave:t3: 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} Fro…

[image] 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.

The relation & lookup data columns are Glide-calculated columns so you won’t see them in the sheet. To be able to have that value in your sheet, you should create a vlookup arrayformula.

Thanks for your response ! @ThinhDinh Could you please tell me how may I create the vlookup arrayformula ? Regards

to see data from glide tables or user specific columns, you have to write them to google sheets using any action with set columns.

Thanks for your response @Uzo could you please give an example ? or tell me how I can do this ?

[Screen Shot 2021-02-23 at 6.26.18 AM] . . [Screen Shot 2021-02-23 at 6.24.28 AM]

You can read more about arrayformula here. [image] Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts Ask for Help Hi, Today I will show you the script that can make copying formulas down work, when it does no…

Hello, I am not sure that these answers above may fix the issue. I cannot see the column created from glide in Google Sheets. Please see the screenshots. Could you please see and advise ? Column created in glide [Capture columm] Column not visible in google sheets [Capture columm google] R…

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 …

Sure I got it thanks @Jeff_Hager @ThinhDinh ! :smiley: 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 sh…

Can you share the editing rights to ariesarsenal@gmail.com ? I can only view as of now.

How to retrieve data after duplicating and relation in Google sheets

Ask for Help

ThinhDinh February 23, 2021, 12:34pm 7

You can read more about arrayformula here.

Topic		Replies	Views
Data calculate in Data editor to Gsheets Ask for Help	10	1194	June 13, 2020
Replicate a Relation Column in Google Sheet Ask for Help	19	1112	October 5, 2021
Llevar columnas de glide a google sheet Ask for Help	2	361	July 2, 2022
Show data in glide sheets Ask for Help	9	352	November 3, 2021
Data from a user-specific column into my google sheet? Ask for Help	26	2653	July 2, 2021

How to retrieve data after duplicating and relation in Google sheets

Related topics