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!
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.
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.
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...)
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!!!
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.
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.
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
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.
RUclips 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.
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 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.
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.
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
Thanks everybody!
Nice to see you again
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!
Welcome back
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.
Same!
Thanks! I was really busy with my business, which is a good thing. RUclips is a good hobby, but it doesn't make a living for me.
Welcome Back
We miss you and miss your beautiful lessons
I was worried you had quit. So thankful for all you have taught me in excel/google. Welcome back!
Welcome back here! I hope there will be new videos regularly, this is clearly the best Google sheet RUclips channel.
Love you sir.I learnt google sheet basics from you.Happy that you are back. From India
Thank you so much for coming back, teacher! You are amazing!!!
Great that you are back with awesome explanations.
I have learnt so many spreadsheet things through your Tutorials. Thank you!
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
Yes. Just select the column and use custom number format as you usually do when it's not a table.
Great great to see a new video!!🎉
Welcome back good to see you 😊
Great to see that you are back. Your videos are always excellent.
Welcome back! Glad to see your perspective on Tables!
This is the best channel of Google Sheets ever
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.
Hi bro, long time no see.
Welcome back
Waiting for so long from you Sir, finally you are back with awesome videos on Google Sheets
the king is back!!
I was just on Reddit last night talking about tables and here you are. Your tutorials are awesome. Thank you!
Thank you sir. I had gained a lot from your videos.
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...)
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!!!
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.
Welcome back.. It's been 1 year...
He is back!!!
Welcome back!
Thank you for the video king! Learned so many things from you!
welcome back my brother nice to see you again
I waited for you every day, my google spreadsheet teacher!
Happy to see you back 😊
So glad you're back ! We missed you ! Great and helpful video as usual.
Welcome back! And again a great tutorial on Google sheets Table!
Yeees! Learnt so much from your videos.
Thanks for your efforts.
I am happy that you are back, I hope you are well
Welcome back dude.
This is very useful!
Welcome back ❤🎉
Welcome back buddy!
Welcome sir
Welcome back 🥳
Thank You!
Welcome back ❤
The King is back!
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.
Sidd...you are so fortunate to know Sirji personally! He is an Incredible Teacher!! Be an Honor to Talk to him in person!!!
Thanks a ton
wow you are back now
Excellent video as always
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
I'm starting to despise web development lately 😀 Every month there is a new way of doing the same thing.
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.
Welcome Back Sir! Thanks for making this valuable content.
Lot's of love from 🇮🇳
👍
Thank you and welcome back! Do you know if we can reference the table using gas as we can for namedranges?
Salam o Aaalikom, it's nice to see you again with your great videos, we miss you a lot :)
😊 thanks!
My mannn
Thank you sir. I've learned so much from your video.
You are amazing.
More video pls..s
So happy to hear your voice again 🙏.
😊 thank you
YOU ARE BACK? 🙏
First. Long time sir.
Welcome Back!!
Welcome back! We love you! :)
I can't wait to see how tables can work with JavaScript
Welcome back.
Good to see you back! I did not find a feature to unconvert a table. I think they forgot to add it?
Yea, the worst part is when you delete the table it deletes the entire thing 🤣
You'll have to copy/paste as values only someplace else.
@@ExcelGoogleSheets I almost fell from my chair when I found out! 😂🤣😂🤣
@@ExcelGoogleSheets I love that the new lines added to tables seen to retain the column formatting much better!
Thanks!
Thank You!
Does the table content has always be static? Can the content be a result set from a formula, eg. FILTER, UNIQUE etc.? thanks
No.
Could you please make a video on the sql in sheets video again because the old one is not working anymore
RUclips 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.
How would tables work with imported data or query formulas that are always changing ranges?
Depends...
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?
No, I don't believe formula updates will grow or shrink your tables, at least not at the moment.
@@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.
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.
what about another spreadsheet?
you have been missed
How is a Table different from a Named Range?
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
What he said ^^
hope google give new method to access table's data from app script, like "getTableList() / getTableByName()" then give object value
Wouldn't just getRange work?
Welcome back ❤🎉
Welcome back ❤
Welcome back
Welcome back ❤
Welcome back ❤