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
Structured tables are awesome, thanks for sharing!
Yes! I'm so excited they're finally in Sheets
About time. One of my top requests, after better named range management.
Absolutely, such a game changer!
Is there any solution or workaround for conditional formatting inside tables not auto-expanding into new rows added?
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
Can you create one with Gemini ..with help me create a table
So far it hasn’t let me do that yet
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 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