Structured tables for Google Sheets

[@Hermiel]

About time. One of my top requests, after better named range management.

[@learnspreadsheets]

Absolutely, such a game changer!

[@NetMediaCCTV]

Structured tables are awesome, thanks for sharing!

[@learnspreadsheets]

Yes! I'm so excited they're finally in Sheets

[@lafamillecarrington]

Totally agree that this is a great new feature. It will definitely cut down on my reliance on Query - which can be confusing for other users. I wonder if the inability to block entries that don't match the required formatting is due to the number of people (me included) who use Google Forms linked to the Table.

[@learnspreadsheets]

Interestingly for now no, setting column types doesnt block, you still need data validation for that

[@rubenmunozverdu7528]

About time!!! Does this have structured references like Excel tables have?

[@rubenmunozverdu7528]

Okay, asked without finishing the video 😂

[@learnspreadsheets]

Partially, they apply to whole columns, not to cells in the same row or headers though

[@EastTactics]

Is there no way to insert colum totals into these new tables?

[@sadburai1]

yeah, wondering that to

[@learnspreadsheets]

You can but manual, if you type in a cell above or below the column =sum( then it will suggest summing that column, but no auto total rows like Excel

[@Tharivololo]

Is there any solution or workaround for conditional formatting inside tables not auto-expanding into new rows added?

[@learnspreadsheets]

I personally preset conditional formatting to many rows below the table currently so it auto expands

[@johnathanmudrovcic6405]

Great content! What about separate filtered views? Example: Original source Table on Sheet 1. Sheet 2 requires a synced filtered view, and when this filtered view on sheet 2 is edited, it updates the data in the original table on sheet 1 (and visa versa). Is this possible and if not, do you know if it’s coming?

[@learnspreadsheets]

Hi that is absolutely possible but with another method, using the FILTER function or QUERY function. Check my videos on QUERY & dynamic arrays in Sheets for more info!

[@Character-j1r]

Can you create one with Gemini ..with help me create a table

[@learnspreadsheets]

So far it hasn’t let me do that yet

[@francoischarette2139]

Hello. Thanks for the video. Now is there a way to retrieve the data using the table name with App Script?

[@learnspreadsheets]

Hi thanks for the question. I believe so but have never tried myself sorry

[@esperanzapadilla6314]

is this already rolled out or is it still under BETA environment?

[@learnspreadsheets]

It’s not in Beta but it’s being gradually released, & Google has said everyone should have it by late June. More info here: workspaceupdates.googleblog.com/2024/05/tables-in-google-sheets.html?m=1