How can I perfom an importrange, unique formula from another glide table using excel formula so that I summerize the values for statistical analysis…

I think importrange() will work between sheets of the same spreadsheet in Google Sheets, but not between Google Sheets and Glide Tables. To import data into a Glide Table from a Google Sheets, I think a CSV import would work well (one time). In a Glide Table you can use the relation, lookup and qu…

Ok, thnak you so much. I have a glide table in which data is added through form submissions. How ever to do some calculations and summaries of the data, I want to bring the key unique values into a column then make a relation , looking up the other information and do some summary calculation on it …

Let’s say you have a Glide Table of sales data and you would like to determine sums by month. You would then create a separated Glide Table called Monthly Sales Report, create 12 rows for 12 months (January, February, … , December), create a relation or query column to point each month to the assoc…

Ya…query works well. here’s another video that might help: [image] litter_in_bin_sign Trash your Excel Formulas Community Resources wave Hey Gliders! By request, I created a video that explains how to replace 14 commonly used Google Sheet/Excel Formulas using G…

Importrange in glide tables using excel formula

Ask for Help

Robert_Petitto December 20, 2023, 7:16pm 5

Ya…query works well. here’s another video that might help:

Topic		Replies	Views
Import Range Ask for Help	5	150	January 19, 2024
Show data in glide sheets Ask for Help	9	350	November 3, 2021
Import Data From Excel & Sheets into Glide Table Feature Requests	33	8225	June 7, 2022
Import your Glide Table into any Google Sheet, with 1 formula! Project Showcase	19	1067	July 16, 2023
Is Data from Glide Tables sync to Google sheets? Ask for Help	8	1646	January 17, 2024

Importrange in glide tables using excel formula

Related topics