Structured tables for Google Sheets
Автокөліктер мен көлік құралдары
Google Sheets' Tables make data far more structured and more like database type data. You can assign data types to each column, use structured references on entire column, they automatically expand with formulas, data validation and more. Change your data inputs into Tables and Google Sheets will work much better.
Create better tables in Google Sheets: • Better tables in Googl...
Auto colour in Google Sheets: • Automatically colour i...
Download example files here: www.xlconsulting-asia.com/you...
00:00 Introduction
01:22 Make a table
02:00 Auto expand
02:54 Group by
03:53 Set data types
04:59 Smart chips data type
07:15 Table templates
07:47 Rename, resize, restyle & revert
09:08 Column options
10:01 Formulas and tables
14:29 Shortcuts
14:52 Multi cell formulas and tables
16:31 Excel Table features not in Sheets
16:56 Data type vs validation
Пікірлер: 14
About time. One of my top requests, after better named range management.
@learnspreadsheets
Ай бұрын
Absolutely, such a game changer!
Structured tables are awesome, thanks for sharing!
@learnspreadsheets
2 күн бұрын
Yes! I'm so excited they're finally in Sheets
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
Hello. Thanks for the video. Now is there a way to retrieve the data using the table name with App Script?
@learnspreadsheets
2 күн бұрын
Hi thanks for the question. I believe so but have never tried myself sorry
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
11 күн бұрын
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 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