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.
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?
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!
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
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.
About time. One of my top requests, after better named range management.
Absolutely, such a game changer!
Structured tables are awesome, thanks for sharing!
Yes! I'm so excited they're finally in Sheets
About time!!! Does this have structured references like Excel tables have?
Okay, asked without finishing the video 😂
Partially, they apply to whole columns, not to cells in the same row or headers though
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?
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!
Hello. Thanks for the video. Now is there a way to retrieve the data using the table name with App Script?
Hi thanks for the question. I believe so but have never tried myself sorry
Is there no way to insert colum totals into these new tables?
yeah, wondering that to
Can you create one with Gemini ..with help me create a table
So far it hasn’t let me do that yet
Is there any solution or workaround for conditional formatting inside tables not auto-expanding into new rows added?
I personally preset conditional formatting to many rows below the table currently so it auto expands
is this already rolled out or is it still under BETA environment?
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