Structured tables for Google Sheets

Рет қаралды 4,046

Күн бұрын

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

Пікірлер: 13

@Hermiel Ай бұрын

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

@learnspreadsheets Ай бұрын

Absolutely, such a game changer!

@NetMediaCCTV 21 күн бұрын

Structured tables are awesome, thanks for sharing!

@learnspreadsheets 11 сағат бұрын

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

@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

@johnathanmudrovcic6405 12 күн бұрын

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 9 күн бұрын

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!

@francoischarette2139 19 күн бұрын

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

@learnspreadsheets 11 сағат бұрын

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