New 2024 Table Feature in Google Sheets!

[@1TreukFlyyy]

Hw to add subtotal line when grouping by category ?

[@matttechtidbits]

Hey that's a great question. I had to spend some time testing some things out, and ultimately that isn't a feature with the tables or the Group by View, however it would be a great feature to be added! That said, the easiest thing I found to do this with would be making a pivot table of the table of data and then grouping it by whatever category. I know not the solution to your question exactly, but you can make a pivot table and count with it. Hopefully helps answer your question, feel free to reply if you had questions on it.

[@monologuesofaconsultant]

Thank you for this timely video, very helpful.

[@matttechtidbits]

You are welcome, glad it is useful to others!

[@warrenanderson412]

I always wondered why Google Sheets didn't have Tables...I guess better late than never, huh? Thanks!

[@matttechtidbits]

Right?? Yeah not quite the level of Excel’s tables but hopefully the start to bridge that gap!

[@LotfyKozman]

@@matttechtidbits I also wonder why the don't have Data Solver, and more options in Paste special!

[@lee-menthiaseptember4072]

The video I was waiting for. Do more of these

[@matttechtidbits]

Hey thanks for the response! I’ll try to do more new feature videos (unless something else what what you liked about this one) 😁

[@lilexcel]

A bit disappointed when the table cannot be refered as a name range or component in @ menu for other spreadsheet. I expected the table in different sheet with importrange or @TableName for reusable component, but well hope that it could be available in the future

[@matttechtidbits]

Yeah for sure. Using it for a bit longer now, another bummer is that formulas cannot be in the header row. Nice step forward with this, but hopefully a lot more added to them! Hopefully using the Send Feedback (down arrow by table name> Send Feedback) we’ll see some more feature like this!

[@AngelaElder999]

I need help getting a second table exactly like the first one to be to the right or left of the original one. I need the table names to be Spring 2024 and Fall 2024, and I want them on the same tab, but scrollable to the right. How the heck can you "insert" a second table next to an existing one.

[@matttechtidbits]

Hey there, great question. It took a bit, but if you highlight the cells you want as the second "Fall 2024" table, then go to Format > Convert To Table, it worked for me to have two different tables together. If you type before formatting them as a table, it just automatically adds to the first table (which is I assume what you had happened as well)! Hope that helps!

[@eristidwialmubarok]

Can we add another tables in existing sheet? so there are have multiple tables tab in one sheet.

[@matttechtidbits]

Hey there, yes you should be able to have multiple tables in a sheet tab! I know some have issues with them if they are close, as they cannot overlap. So just be mindful that they aren’t too close if you need to add more columns or rows. You’ll need to highlight the area you want and right click > format as table. Or use the menu bar option in formatting > format as table. Hope this helps!

[@BadreddineBaim]

great video thanks

[@PVP-learn]

Hi, a new row does not automatically get added to the table if I type a new row next to the table, as you've shown. Am I doing anything wrong?

[@matttechtidbits]

Hmmm. Odd, no I don't think so, but also I am not seeing that still on my end (aka I still get new rows added like the video). Do you happen to have hidden or grouped row by it? that was the only way I could make my table not automatically format to table when I type with what looks like the next row. Otherwise do you happen to be using a different web browser than Chrome? I just know from others Firefox specifically didn't work well with these tables. Otherwise perhaps an update to the browser and /or computer? Sorry not much help probably but hopefully gives a few ideas!

[@Seikha]

Thanks for the video :) loads of helpful stuff, I was wondering though if you know whether it's possible to edit the placeholders in the table. For example I would like to have the default entry in a date column be the end date of a project, then edit it to a closer date if required.

[@matttechtidbits]

Hey, thanks glad it was helpful to you! As for your question, it seems like placeholder are not editable at this point unfortunately. This is assuming the placeholders like ## under a column that is a number, or m/d/yyyy for dates. I did check quick and on support.google.com/docs/answer/14239833?hl=en&sjid=3831749139336395473-NC the article sort of confirms this, although not specifically to your question: "For some column types, placeholder chips are auto populated to allow for easy data entry. To turn off placeholder chips for a column". To me, the auto populated makes it sound like it is more meant to give a quick view to users on what should be entered in the columns. You could put that in a feature request as that would be something I see could be useful to others! A potential alternative solution could be adding a data validation rule to only allow dates in a range of dates or before/after a specific date. I did put a video out going through these number data validation rules if that is something you wanted to explore: kzbin.info/www/bejne/jZ6vi4lmlKqIetE

[@andersonbonamigo5961]

but, in query function it do not work with "=query(Table1[#All], "SELECT Talbe1[full_name], Talbe1[Department],..."). Is there any way?

[@matttechtidbits]

Hey there, yes instead of using the Table1[full_name] as the SELECT statement, you would either need to use the column number. So Something like =QUERY(Table1[#ALL],"SELECT Col1,Col2,..." OR you can use whatever the Column letters are. So, =QUERY(Table1[#ALL],"SELECT A,B,..." For QUERY, it can only can use the table as the data to query from. Hopefully this helps for your question! Another thing if you are using it with FILTERS, or you don't want the header row, I just saw you can reference just "Table1" which does everything except the header row. Which matches what the Table1[first_name] has been doing. Just in case you didn't use FILTER due to mismatched sizes.

[@karla3541]

Hello! I have a question. When I put a table under another one and I keep writing in the table above (I mean I keep adding rows), the table below is not scrolled, it starts to overwrite the information. Do you know how to solve this? I hope I have explained myself well. Thanks!

[@matttechtidbits]

Hey there. Yes that is expected behavior, assuming you are just typing below it and the table range expands down to that row you are writing on. It doesn't automatically add rows as you go down, but instead formats that row to the table. So you would need to insert more rows - either right click the row number > insert row, or you can use the keyboard shortcuts: MAC: Ctrl + Option + i, press r then b PC: in Google Chrome: Alt + i, then w PC in other browsers: Alt + Shift + i, then w That said, I would recommend using a new sheet for a new table, or have them in different columns, assuming more rows would be added compared to more columns. That's probably the easiest way, but also know depending on the setup may not be ideal. Hope something here helps!

[@karla3541]

@@matttechtidbits thank you!!

[@jeremybonios]

Can this be used with Google Form responses?

[@matttechtidbits]

Hi, yes I used these for the “form response 1” and does work. When new entries are added, they are added to the table!

[@mooripo]

Thanks

[@ritafelder2818]

Is there a way to add information above the table? When I add info and then insert a table; it seems to either insert the table over the information or deletes that information altogether.

[@matttechtidbits]

Hey, so is this if you have a preexisting unformatted table of data, and when you press "insert table" it goes over the information? If so, I think you need to select the range you want to convert, right click, then select "format as table". Hopefully that is the question, sorry if I misunderstood!

[@huzaifahshah3841]

Thanks Sir❤

[@vlrvrl4443]

Thank you for your video M@tt! What about table in app script? Can we reference them in script?

[@matttechtidbits]

Hey great question. To my knowledge and trial, no not at this point unfortunately. I’m not an expert in scripts, but I tried referencing a table in a script I’ve use regularly and didn’t recognize that as a valid range. I also don’t see any news about new script options, but hopefully soon it will be possible!

[@spreadsheetNinjaNerd]

This looks fabulous! Thanks for the demo :) Will we be able to read/write to tables with google apps script?

[@matttechtidbits]

Of course, thanks for watching! At this point, and from what I’ve seen, we cannot reference it as the table. you still can the “regular way” by referencing the cells. I think that would be a great addition! If you use the “send feedback” button from the table hopefully enough of us request it to be added soon!

[@EnglishWithEnes]

Just out of curiousty, are you left-handed and use your mouse on the left handside of your keyboard?

[@matttechtidbits]

1. Yes I am and yes to the left side! 2. How or what indicated that to you? I’m just genuinely curious…and also impressed!

[@EnglishWithEnes]

​@@matttechtidbitsat 16:12 you sprinkled "j" over the sheet while moving your cursor. Your right index finger falls on the "J" key when it's on the home row. So, you must have used your left hand to use your mouse, which would be convenient to place to the left. Otherwise, if you were to use your right hand to use your mouse and spam a letter, your left hand wouldn't have troubled to reach the "J" key; you would have just pressed "F" key. I really felt like Sherlock.

[@matttechtidbits]

That’s amazing. Totally makes sense. I was guessing hearing clicks of mouse on left side or something with the audio. I hope you do some mystery writing or something!

[@kirksvillewebdesign]

Can we embed these tables?

[@matttechtidbits]

Hi, great question! At this point it seems like we cannot embed unfortunately - at least based on how you can with, say, a graph. You could still use the "publish sheet" to be able to see the table range. Hopefully that will be a feature coming out sometime!

[@kirksvillewebdesign]

@@matttechtidbits Bummer. I was really expecting a special embed ability for these. I was going to embed on my Google Sites and enjoy the Notion-like management. I already submitted my feedback on the Sheet. Thanks for sharing the copy.

[@monologuesofaconsultant]

Thank you for this timely video, very helpful.

[@MarkVicente-gw7of]

how do we reference a table name in a google apps script?

[@matttechtidbits]

Hey Great question, from my knowledge right now, (and checking the Release Notes developers.google.com/apps-script/docs/release-notes ) there doesn't seem to be a way to reference the table other than what we'd do previously with getRange or referencing cells. Hopefully Google will add that soon. Using the "send feedback" may help speed that up if enough people request it!