Your Simple Guide to Using NEW Tables in Google Sheets 2024!

[@CharlesWright-r4g]

@SharonsTutorials may I ask what software you use to record your videos? I love the camera bubble. :)

[@SharonsTutorials]

I use ScreenPal - it's one I've been using for years as it's so user-friendly and simple :)

[@lafamillecarrington]

Great update for Sheets. I use a Google Form in a website to collect data, and wonder if the reason for not excluding invalid data, is that it might cause problems when people try to submit the form?

[@SharonsTutorials]

Maybe... although your form can be set to accept specific types of responses so shouldn't have invalid data? Also I think when the responses are opened in a Sheet, the table doesn't have set column types to begin with, so it wouldn't know whether the data downloaded is invalid. But I think I've probably misunderstood what you mean... 😂

[@lafamillecarrington]

@@SharonsTutorials There are probably a lot of people using Forms who don't realise that you can use response validation (and I have to relearn how to do it each time!).

[@SharonsTutorials]

@@lafamillecarrington Thanks that gives me an idea for my next tutorial 😂

[@SharonsTutorials]

@@lafamillecarrington just in case you're interested: kzbin.info/www/bejne/e6badXasqsuFkM0 (I've now published a full tutorial on response validation) 😊

[@reenastutoring]

Hi! I am trying to upload my files into the cell using the 'smart chip' option, however, it is only letting me choose between a limited number of documents in my drive. I have tried changing the format of the other documents but still no luck. Do you know anything about uploading files into the cell?

[@SharonsTutorials]

I think it only shows a certain number of files in the list so you just need to start typing the file name or keyword (after you type @ and click on Files) for the list to update & hopefully it'll contain the right file for you to click on - hope that helps?

[@reenastutoring]

@@SharonsTutorials You are brilliant, thank you so much!

[@SharonsTutorials]

@@reenastutoring No worries, I'm glad it worked for you 😊

[@reenastutoring]

@SharonsTutorials, I was wondering if you could help me. Unfortunately, when I choose the 'Date' or 'Currency' option, it sets to American formatting (m/d/yyyy and $)... Do you know how I can change it to UK formatting (dd/mm/yyyy and £)? I have tried changing the date formatting via format tab > date > custom date but the placeholder do not change and when I choose 'Date and Time' this format does not work. Please let me know if you can help, I would really appreciate it!

[@SharonsTutorials]

Try going into File then Settings and make sure the Locale section is set correctly e.g. UK - this should then set all of your currency & date formatting to UK. Let me know if that still doesn't work & I'll have a play around :)

[@reenastutoring]

@@SharonsTutorials You are amazing, thank you so so much!! ❤

[@SharonsTutorials]

@@reenastutoring Thanks & you're welcome! I gather it worked okay 🤗

[@cooltimetravel4959]

I really like this tool, but can you only do One table per sheet using this method?

[@SharonsTutorials]

If you're converting existing data then you can have as many tables as you like in the one sheet. But if you're using one of the pre-built templates, then it will automatically insert the table in a new sheet each time. Hope that helps :)

[@cooltimetravel4959]

@SharonsTutorials Thank you, I figured out a work around to put multiple into one sheet without existing data

[@SharonsTutorials]

@@cooltimetravel4959 oooh sounds intriguing, if you feel like sharing then please do... 😊

[@mariobutkovic8033]

@@cooltimetravel4959 Can you please share how? Thank you in advance !

[@krishnatate4765]

Nice ma'am ❤

[@ZacharyAdams-lk7dz]

Great, but not supported yet within iOS, which is very unfortunate.

[@SharonsTutorials]

Not sure when that's happening...

[@DanChan-km8mf]

Great presentation! I am an IOS user and don’t use a mouse. It would be helpful if the presentation included options available to IOS users like me. Thank you

[@SharonsTutorials]

Thanks for your suggestion :) However, none of my tutorials cover anything on iOS as I like to be able to physically show step-by-step what I'm doing and I'm not an Apple user, sorry!

[@MattTemes]

This is the most horrible update. Editing the sheet stops any submission (we need check boxes with color coded rows for multiple people) unless we re-link the form. Re-linking the form deletes any new data/formatting and just forces the tables on the sheet again. I hope they either let us opt out of this or get rid of it altogether. Made our workplace a disaster so we are back to pen and paper ledgers since we lost hours of productivity because of this.

[@SharonsTutorials]

That sounds like a nightmare! I have a form where I've gone into the sheet & reverted the table to unformatted data, then I've added a column at the beginning of the data (for my own reference) and included conditional formatting within the sheet and it still accepts submissions & formats them correctly - so I'm not sure what you're doing different? Unless you're inserting additional columns within the data so it disrupts the form order?