New 2024 Table Feature in Google Sheets!

NEW 2024 TABLE FEATURE IN GOOGLE SHEETS!

Here’s a copy if you want to edit and test out the table options:

Checkout all the updates up to October 2024, like IMPORTRANGE(), in this latest video:

As mentioned in the video, the most exciting parts for me are:
1. Easily Format your data
2. Easily validate your data with “column types”
3. Filtering, Sorting, and other options to switch in your table all in one space.
4. Reference the table in other functions / Formulas or PIVOT Tables.
---
⏳Timestamps:
00:00 Introduction
00:55 Google’s Blogpost and TLDW
03:00 Pre-built Table Examples and Getting Started
4:16 Column Types
5:17 Highlighting Previous “Table Building”
5:44 Creating Table With Spreadsheet Data
6:17 Sorting and Filtering Tables
7:04 Creating Group By Views
9:53 Editing Column Types
11:24 Adding New Data
12:08 Referencing a Table
13:58 Table[ALL] Referencing
17:41 Some Table Limitations (IMPORTRANGE & Charts)
20:56 Referencing While Filtered
23:21 Conclusion
23:51 End Slides
--

🗣️Socials:

🎵Music is "WFH" by Ambiosynthesis
—

#️⃣#sheets
#spreadsheet
#googlesheets
#technology

[johndaniel]

Group view isn't working well when you allow multiple selections, hope they will fix this

[spreadsheetNinjaNerd]

This looks fabulous! Thanks for the demo :)
Will we be able to read/write to tables with google apps script?

[monologuesofaconsultant]

Thank you for this timely video, very helpful.

[Seikha]

Thanks for the video :) loads of helpful stuff, I was wondering though if you know whether it's possible to edit the placeholders in the table. For example I would like to have the default entry in a date column be the end date of a project, then edit it to a closer date if required.

[lee-menthiaseptember]

The video I was waiting for. Do more of these

[eristidwialmubarok]

Can we add another tables in existing sheet? so there are have multiple tables tab in one sheet.

[lilexcel]

A bit disappointed when the table cannot be refered as a name range or component in @ menu for other spreadsheet. I expected the table in different sheet with importrange or @TableName for reusable component, but well hope that it could be available in the future

[AngelaElder]

I need help getting a second table exactly like the first one to be to the right or left of the original one. I need the table names to be Spring 2024 and Fall 2024, and I want them on the same tab, but scrollable to the right. How the heck can you "insert" a second table next to an existing one.

[karla]

Hello! I have a question. When I put a table under another one and I keep writing in the table above (I mean I keep adding rows), the table below is not scrolled, it starts to overwrite the information. Do you know how to solve this? I hope I have explained myself well. Thanks!

[PVP-learn]

Hi, a new row does not automatically get added to the table if I type a new row next to the table, as you've shown. Am I doing anything wrong?

[TreukFlyyy]

Hw to add subtotal line when grouping by category ?

[EnglishWithEnes]

Just out of curiousty, are you left-handed and use your mouse on the left handside of your keyboard?

[ritafelder]

Is there a way to add information above the table? When I add info and then insert a table; it seems to either insert the table over the information or deletes that information altogether.

[andersonbonamigo]

but, in query function it do not work with "=query(Table1[#All], "SELECT Talbe1[full_name], Talbe1[Department], ..."). Is there any way?

[jeremybonios]

Can this be used with Google Form responses?

[warrenanderson]

I always wondered why Google Sheets didn't have Tables...I guess better late than never, huh? Thanks!

[MarkVicente-gwof]

how do we reference a table name in a google apps script?

[monologuesofaconsultant]

Thank you for this timely video, very helpful.