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
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
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.
Interestingly for now no, setting column types doesnt block, you still need data validation for that
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!
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
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
Can you create one with Gemini ..with help me create a table
So far it hasn’t let me do that yet
Is there no way to insert colum totals into these new tables?
yeah, wondering that to
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
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