Google Sheets Tables & Formulas

[@ExcelGoogleSheets]

Thanks everybody!

[@xiaer]

Nice to see you again

[@RegRegi-n6q]

I kindly request a video tutorial demonstrating the use of Document AI for extracting insights from documents, statements, that might be followed by data visualization in Looker Studio and integration with spreadsheets.

[@MISComputerNET]

3 days ago I was talking to a friend of mine about this channel's owner and had told him that he is one of the best spreadsheets teacher on the digital. Now I really am glad to see he's back after a long time. Welcome back!

[@LawCoder]

I see I'm not the only one happy to see you back. Please keep it up, don't abandon the channel for so long. I learned JavaScript thanks to this channel and already write my own applications in nodejs, svelte, tailwind and use GAS as backend in them. With pleasure and deep sense of gratitude, your subscriber from Russia.

[@richardthemagician8991]

Same!

[@ExcelGoogleSheets]

Thanks! I was really busy with my business, which is a good thing. KZbin is a good hobby, but it doesn't make a living for me.

[@wkardita]

Same... Your channel has helped me in automating my administrative activity, it had created more than 1mio covid letter pdfs during the pandemic before being taken over by the product team

[@ajadsingh1652]

Welcome back

[@JoshPeterson]

I was just on Reddit last night talking about tables and here you are. Your tutorials are awesome. Thank you!

[@RyanHoilman-pj4pn]

I was worried you had quit. So thankful for all you have taught me in excel/google. Welcome back!

[@TheDroberto87]

Welcome back here! I hope there will be new videos regularly, this is clearly the best Google sheet KZbin channel.

[@SheetsNinja]

Welcome back! Glad to see your perspective on Tables!

[@Soundofegypt]

Welcome Back We miss you and miss your beautiful lessons

[@rogersantoyo]

So glad you're back ! We missed you ! Great and helpful video as usual.

[@SanthoshKumar-e5t]

I have learnt so many spreadsheet things through your Tutorials. Thank you!

[@ManojGuptahome]

Thank you very much for yet another informative post. Is there any way to format currency or date or even amounts in a particular format

[@ExcelGoogleSheets]

Yes. Just select the column and use custom number format as you usually do when it's not a table.

[@videosGNP]

The more I watch this video the more I am learning. And being able to implement the TABLE feature in my workload is the best part. Thank you again!

[@uribudnik]

Great to see that you are back. Your videos are always excellent.

[@hends.tabanez]

This is the best channel of Google Sheets ever

[@douglasteixeiragoncalves6084]

Thank you so much for coming back, teacher! You are amazing!!!

[@Allen-L-Canada]

You are back, I was thinking about you from time to time, especially when I use my Googlesheet. I was thinking you must have moved on to AI stuff already. :) so glad that you are back.

[@MattDog_222]

Oh wow I havent seen one of these thumbnails show up in my feed in a long time. I first subscribed 5+ years ago when working on some random side project in high school, and then stumbled across ur import HTML/XML parsing videos and thought it was some crazy magic I was populating my spreadsheets with... and now I'm a web developer. Thank you xD

[@ExcelGoogleSheets]

I'm starting to despise web development lately 😀 Every month there is a new way of doing the same thing.

[@pancux670]

Waiting for so long from you Sir, finally you are back with awesome videos on Google Sheets

[@arctichawk3502]

Welcome back! And again a great tutorial on Google sheets Table!

[@compjotter2556]

Great that you are back with awesome explanations.

[@MichaelBielski]

I saw the release of tables in Sheets and just hadn't gotten around to grokking it yet. You've done it for me, and in a very easy to understand way. Thank you! (OMG I have so much work to re-do now...)

[@shekhasif604]

Welcome back good to see you 😊

[@melenev]

I've been wondering for the past few days, if you'd be back to cover this latest addition to GSheets ... Thank you, Thank you Thank you...Glad you're back.

[@Electric-Bob]

Teacher...Long Time No See! This Video I believe will Solve a Huge Problem with my Little Ongoing Project I have been Stuck On for Some Time!! Thanks...your The Best!!!

[@siddharthjain6629]

I am Glad to see you back sirji. You spreadsheet tutorial are the best tutorial I have ever seen. Also I get a lot of respect because of you at my workplace. You are doing a great job keep doing it Sirji.

[@Electric-Bob]

Sidd...you are so fortunate to know Sirji personally! He is an Incredible Teacher!! Be an Honor to Talk to him in person!!!

[@ExcelGoogleSheets]

Thanks a ton

[@ugzmug8103]

welcome back my brother nice to see you again

[@DreamWorker0]

I waited for you every day, my google spreadsheet teacher!

[@tecnoideas7436]

The King is back!

[@shubhamcreation337]

Welcome Back Sir! Thanks for making this valuable content. Lot's of love from 🇮🇳

[@ExcelGoogleSheets]

👍

[@anhjou]

the king is back!!

[@hivinay83]

Thank you sir. I had gained a lot from your videos.

[@Nataliia_B]

Welcome back! Thank you very much for the new video

[@mistermtwentyforseven]

Welcome back buddy!

[@mohitsharma-ym3km]

Happy to see you back 😊

[@ozgurugur7609]

Thank you for the video king! Learned so many things from you!

[@jamesepace]

Cool! I hadn't realized they added Tables! Thanks for the video.

[@sharitambasco9780]

Welcome back. I hope you are doing well. You are my favourite content creator and I have made so many useful things based off of your lessons. If life takes you away from the channel we will all understand, but for now I am so happy to see you back.

[@Krishnadhurwey1986]

Welcome back dude.

[@guihprado3366]

Great great to see a new video!!🎉

[@xaquison]

Excellent video as always

[@conuk35]

Yeees! Learnt so much from your videos. Thanks for your efforts.

[@khaledaboelhamd]

I am happy that you are back, I hope you are well

[@OussamaELAHMAR]

Salam o Aaalikom, it's nice to see you again with your great videos, we miss you a lot :)

[@ExcelGoogleSheets]

😊 thanks!

[@ryanduy]

Hi bro, long time no see. Welcome back

[@DIN-Norm]

Welcome back!

[@muraly3523]

Love you sir.I learnt google sheet basics from you.Happy that you are back. From India

[@vlrvrl4443]

Thank you and welcome back! Do you know if we can reference the table using gas as we can for namedranges?

[@hends.tabanez]

Welcome back 🥳

[@ExcelGoogleSheets]

Thank You!

[@jdml3575]

He is back!!!

[@DaveGhidiu]

Thanks!

[@ExcelGoogleSheets]

Thank You!

[@AmmarMerhbi77]

Welcome back.. It's been 1 year...

[@lpanebr]

Good to see you back! I did not find a feature to unconvert a table. I think they forgot to add it?

[@ExcelGoogleSheets]

Yea, the worst part is when you delete the table it deletes the entire thing 🤣

[@ExcelGoogleSheets]

You'll have to copy/paste as values only someplace else.

[@lpanebr]

@@ExcelGoogleSheets I almost fell from my chair when I found out! 😂🤣😂🤣

[@lpanebr]

@@ExcelGoogleSheets I love that the new lines added to tables seen to retain the column formatting much better!

[@samniengpollong7841]

Thank you sir. I've learned so much from your video. You are amazing. More video pls..s

[@gabrielamilla]

Welcome back! We love you! :)

[@sam_safari]

wow you are back now

[@desrajsingh1345]

So happy to hear your voice again 🙏.

[@ExcelGoogleSheets]

😊 thank you

[@bryan1311]

First. Long time sir.

[@nikhilbhukhri2838]

Welcome sir

[@bigbrother1211]

This is very useful!

[@AlaaNoureldien]

Welcome back ❤

[@ilhamyahyamiy720]

My mannn

[@cric8482]

Thanks for this very good video and welcome back ! Take care when using array formula inside a table. If you sort the table by a column, the results may be strange or wrong.

[@ExcelGoogleSheets]

good point!

[@Ben-cc3fj]

Welcome Back!!

[@Fshhady]

thank you for great video. I would like to ask if we can deal with tables from Google Apps Script?

[@xaquison]

YOU ARE BACK? 🙏

[@jj342]

Top stuff!

[@66Komodo]

Welcome back.

[@iggymach]

NIce vid. You just earned a new subscriber

[@krishnatate4765]

Thank u google sheet MASTER ❤

[@richardthemagician8991]

I can't wait to see how tables can work with JavaScript

[@alansavage3549]

Hey thanks. Now I get it.

[@Allen-L-Canada]

Does the table content has always be static? Can the content be a result set from a formula, eg. FILTER, UNIQUE etc.? thanks

[@ExcelGoogleSheets]

No.

[@guihprado3366]

How would tables work with imported data or query formulas that are always changing ranges?

[@ExcelGoogleSheets]

Depends...

[@marychan-e1t]

Where can I find all your google sheets practice files for all your videos here on your KZbin Channel?

[@pflinn]

Is there a way to dynamically update table headers from another sheet or table? When I enter a formula in the header it is not allowed.

[@francoischarette2139]

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

[@ExcelGoogleSheets]

Doesn't just the usual getRange() method work?

[@francoischarette2139]

@@ExcelGoogleSheets Of course you can use the getRange() method. But let's say you know the name of the table but not it's location. It would be nice to have a method getTableByName(). In Excel VBA we can do: set oTable = ActiveSheet.ListObjects("TableName"). Do you know if there is something similar in Google Sheets?

[@francoischarette2139]

@@ExcelGoogleSheets Of course I can use the getRange() method. But what if I don't know the location of the table? In Excel VBA I can access the table using it's name with ActiveSheet.ListObjects.Item("tableName"). Do you you if something similar exist in Google Sheets?

[@jj342]

Can i set a default view? for a table ...group by one of the columns, I want everyone to see it with this view

[@cric8482]

Hi. Any idea if it is possible to populate a table with data using appscript ? Seems to be defined as a "banding" Create a banding : spreadsheet.getRange('D7:E7').activate(); var banding = spreadsheet.getRange('D7:E7').getBandings()[0]; banding.setRange(spreadsheet.getRange('D7:E700')) .setHeaderRowColor('#356854') .setFirstRowColor('#ffffff') .setSecondRowColor('#f8f9fa') .setFooterRowColor(null); Of couse an excellent video (as always) will be appreciated 🙂

[@mazaruddin9261]

Could you please make a video on the sql in sheets video again because the old one is not working anymore

[@ExcelGoogleSheets]

KZbin removed the video for violating their terms of service. They said it was removed for posting offensive content, bullying. I've tried to appeal, but everything is automated these days, so it was rejected and their customer service is AI bots too and it said they stand behind their decision. Can you believe it? :) It was a one hour video, it took over a week to make it. Anyways, I don't think I'll be posting one again, sorry.

[@richardthemagician8991]

Do you have a question. Let's say make a table. For the data and column one, I want to pull in data from another sheet. Something like a form response. So every time I get a new form response, the array formula will pull the data in to the table. Will that expand the table as well? And if I delete data from the table, will it automatically shrink the table range? For example, if I'm pulling in data from another sheet using an array formula, if I delete one of the rows from the data range, then the listing column one of the table will decrease. Will that affect the table range itself?

[@ExcelGoogleSheets]

No, I don't believe formula updates will grow or shrink your tables, at least not at the moment.

[@richardthemagician8991]

@@ExcelGoogleSheets gotcha. I appreciate the reply. What about pulling in data within the ray formula? Do you think that might work? It would at least be one problem solved.

[@ExcelGoogleSheets]

I don't think array formula will grow or shrink the table. The purpose of the table is for formulas to react to table growth, not the other way around.

[@Allen-L-Canada]

How is a Table different from a Named Range?

[@StefanoVerugi]

I think Named Range just replaces usual format like B2:G17 with a "name" Table instead leverages on the column name reference and other features shown in the video

[@ExcelGoogleSheets]

What he said ^^

[@Medsabry98]

what about another spreadsheet?

[@alihakanmutluay]

you have been missed

[@sergheyzaporojanu6872]

useless feature they picked up from excel... I think Google just has to focus on their innovation more and never look back at that old and stupid Excel.... Everybody loves GSheets because it's better than Excel. And now they want to be like Excel?! really?! 😅

[@ExcelGoogleSheets]

I find your logic very odd. The entire Google Sheets project is a copy of Excel to begin with. How are you upset that they copy Excel features all of the sudden? What innovation has Google Sheets made? I haven't seen anything innovative in Google Sheets since I've been making videos about it for 7-8 year now.

[@sergheyzaporojanu6872]

@@ExcelGoogleSheets IMPORTRANGE to begin with. UI, appscript on JavaScript, Query etc...

[@ExcelGoogleSheets]

@@sergheyzaporojanu6872 As far as I'm concerned, none of that was improved in any way within the last 7-8 years. They couldn't even improve QUERY to support basic SQL like join statements. Don't get me wrong, it's not like I dislike Google Sheets, but at this point it has fallen behind. The only good things that were added in Google Sheets within the last 8 years were all thanks to Excel, like LAMBDA, named functions, REDUCE, MAP, BYROW, TOCOL, WARPCOL etc.

[@ExcelGoogleSheets]

​@@sergheyzaporojanu6872 As far as I'm concerned, none of that was improved in any way within the last 7-8 years. They couldn't even improve QUERY to support basic SQL like join statements. Don't get me wrong, it's not like I dislike Google Sheets, but at this point it has fallen behind. The only good things that were added in Google Sheets within the last 8 years were all thanks to Excel, like LAMBDA, named functions, REDUCE, MAP, BYROW, TOCOL, WARPCOL etc.

[@sabrananda]

hope google give new method to access table's data from app script, like "getTableList() / getTableByName()" then give object value

[@ExcelGoogleSheets]

Wouldn't just getRange work?

[@AlaaNoureldien]

Welcome back ❤

[@mazaruddin9261]

Welcome back

[@PromiXes]

Welcome back

[@AlaaNoureldien]

Welcome back ❤

[@AlaaNoureldien]

Welcome back ❤

[@AlaaNoureldien]

Welcome back ❤🎉

[@AlaaNoureldien]

Welcome back ❤🎉