Тёмный
Better Sheets
Better Sheets
Better Sheets
Подписаться
Tools, Templates, and Tutorials for Google Sheets Users!
Helping you excel in Google Sheets, for all time.

👩‍💻 TUTORIALS
Unlock the full potential of Google Sheets with our expert guidance and step-by-step tutorials. Whether you're a beginner or an advanced user, we have something for everyone. If you use spreadsheets, we've got you covered.

🖼️ TEMPLATES
Explore our collection of free templates at free.bettersheets.co
Designed to streamline your workflow and save you valuable time.

⚙️ TOOLS
Enhance your Google Sheets experience with our free add-ons. Powerful tools extend the functionality of Google Sheets, allowing you to automate tasks, generate better designs, and perform complex calculations effortlessly ( like Spintax). Sell sheets with OnlySheets and market them better with Coupon Code Maker.

Ready to take your spreadsheet skills to the next level? Visit us at Bettersheets.co to learn more and access our wealth of resources. Empowering you to succeed!
How To Delete a Spreadsheet
2:00
23 часа назад
How to Copy a Tab in Google Sheets
1:18
23 часа назад
How to Color Tabs in Google Sheets
0:55
День назад
Ultimate Word Count Tracker
18:13
День назад
Free Public API Data in Google Sheets
1:00:24
День назад
How to Publish Spreadsheet to Web
1:33
14 дней назад
How to Embed a Single Tab in a Website
1:29
14 дней назад
How to Embed a Spreadsheet in a Website
0:54
14 дней назад
How to Publish One Tab to Web
1:08
14 дней назад
Jump to Specific Cell Automatically
1:21
21 день назад
Комментарии
@maxyusupov9508
@maxyusupov9508 День назад
hello Andrew, nicely done app using cardservice, i am facing bit problem i have created addon which function well from addon side image, but it is not displaying the addon from the menu which is created same like your it is not triggering hompage function, can you help me out ?
@paywanddelshad7722
@paywanddelshad7722 День назад
Man you just made the hell out of the google sheets
@BetterSheets
@BetterSheets День назад
Is that a good thing?
@paywanddelshad7722
@paywanddelshad7722 День назад
@@BetterSheets yes absolutely this is the best tutorial I have seen regarding this subject well thanks man keep it up and God bless you.
@jegsarkany2249
@jegsarkany2249 2 дня назад
what software is this?
@BetterSheets
@BetterSheets 2 дня назад
Google Sheets
@Ghost-T3
@Ghost-T3 День назад
Google Sheets?!?!
@Ghost-T3
@Ghost-T3 3 дня назад
Huh, nice
@BetterSheets
@BetterSheets День назад
Sweet
@kathrinemoore8183
@kathrinemoore8183 3 дня назад
is there a version of this for excel?
@BetterSheets
@BetterSheets 3 дня назад
I dont know. I use Google Sheets
@LuisGrolez
@LuisGrolez 3 дня назад
Best upgrade to google sheet
@BetterSheets
@BetterSheets 3 дня назад
🙏
@hollow_grimm
@hollow_grimm 3 дня назад
Does this also work on the mobile app?
@martinusriovanni4632
@martinusriovanni4632 3 дня назад
Can you grab the data from the cell in another sheet as well as it's notes?
@BetterSheets
@BetterSheets 3 дня назад
Maybe with Apps Script
@JosephYanni
@JosephYanni 7 дней назад
Can there be a cell or sheet that only you can view? Can you password protect a sheet or cell?
@BetterSheets
@BetterSheets 6 дней назад
Every sheet is one only you can view... until you share it.
@khov
@khov 7 дней назад
there is any way to do that but still able to filter rows ? if i do that the use cannot use filter
@BetterSheets
@BetterSheets 6 дней назад
Try the import range to another tab and then use Filter. Or the FILTER( ) formula
@khov
@khov 7 дней назад
ITS POSSIBLE PROTECT A CELL AND STILL BE ABLE TO USE FILTER ?
@BetterSheets
@BetterSheets 7 дней назад
Yes
@khov
@khov 7 дней назад
@@BetterSheets show me how because if i create filter on the columns name but there is a protect cell that use will not be able to use filter
@BetterSheets
@BetterSheets 7 дней назад
​@@khovtry using FILTER formula on another tab to filter the data you want.
@SoupMagoosh
@SoupMagoosh 7 дней назад
This is why we normalise our databases 😌
@BetterSheets
@BetterSheets 7 дней назад
Sing it loud!
@RuthLamech
@RuthLamech 8 дней назад
What if I want to get the code of the already made google sheet
@BetterSheets
@BetterSheets 8 дней назад
Go to Extensions 》Apps Script
@maryjoyparagoso8400
@maryjoyparagoso8400 9 дней назад
I love it.
@BetterSheets
@BetterSheets 7 дней назад
I love you!
@maryjoyparagoso8400
@maryjoyparagoso8400 9 дней назад
I can't seem to have it work, I'll sleep for now. :)
@BetterSheets
@BetterSheets 8 дней назад
Try again!
@Ttrade
@Ttrade 10 дней назад
Greet video!!! Thank dude
@BetterSheets
@BetterSheets 9 дней назад
Thank you! Keep coming back for more!
@momorama8832
@momorama8832 10 дней назад
Thats a bit hard ngl
@BetterSheets
@BetterSheets 9 дней назад
But its fun!
@MataSurya-o6c
@MataSurya-o6c 12 дней назад
hello brother, is it possible that automatically when a member fills in their date of birth data on the Google form, it will be filled in automatically on the calendar, and there will be a birthday notification every year on the calendar?
@BetterSheets
@BetterSheets 7 дней назад
you can have any automation run "every day" and check for the birthday. so yes this, what you describe, is possible.
@SeanCody-f9l
@SeanCody-f9l 12 дней назад
Thanks, how do you extract links from a site?
@BetterSheets
@BetterSheets 12 дней назад
Depends on the site
@gamingindia3288
@gamingindia3288 13 дней назад
What's option key??
@BetterSheets
@BetterSheets 7 дней назад
On the keyboard
@gamingindia3288
@gamingindia3288 7 дней назад
@@BetterSheets I don't see no option key lol
@asiabibi2113
@asiabibi2113 16 дней назад
Hi
@BetterSheets
@BetterSheets 16 дней назад
Yo
@momorama8832
@momorama8832 17 дней назад
The exact same formula is giving an error: " Filter has mismatched range sizes. Expect row count 99. Actual count 103."
@BetterSheets
@BetterSheets 17 дней назад
Make sure your rows are same in colum references.
@momorama8832
@momorama8832 17 дней назад
It worked omg I'm so stupid thankyou​@@BetterSheets
@iainparsons9788
@iainparsons9788 19 дней назад
Confirm that this is a read only embed and not editable?
@BetterSheets
@BetterSheets 19 дней назад
yes it's not editable
@ChrissiesPurpleLibrary
@ChrissiesPurpleLibrary 19 дней назад
Thank you so much! This video was so informational and easy to understand. Your passion was evident. New sub!
@BetterSheets
@BetterSheets 19 дней назад
feel free to ask me anything Chrissie!
@chrismartin3985
@chrismartin3985 19 дней назад
Nice and straight to the point presentation of this new interesting feature. However when accessing such dropdown list from a mobile touch device, I cannot find a way to multiselect, it looks like it falls back to single selection mode which is a problem
@BetterSheets
@BetterSheets 19 дней назад
That does seem like a problem!
@iamGobinda
@iamGobinda 20 дней назад
Is it safe to use this? Is there any way to secure the APIs?
@BetterSheets
@BetterSheets 20 дней назад
Yes. You can secure it as much as you want.
@mohammedsaqlainshaikh7029
@mohammedsaqlainshaikh7029 20 дней назад
Great information but are you looking for a video editor?
@BetterSheets
@BetterSheets 20 дней назад
Not today
@lydgiajarvis337
@lydgiajarvis337 22 дня назад
I get this error message: Error Array result was not expanded because it would overwrite data in B1. what would you suggest? thanks
@BetterSheets
@BetterSheets 21 день назад
Delete whatever is in B1
@lydgiajarvis337
@lydgiajarvis337 21 день назад
@@BetterSheets Thank you! I ended up having to delete everything in the sheet and then it magically copied it in from the original. Thanks!
@BetterSheets
@BetterSheets 21 день назад
@@lydgiajarvis337 sounds like you fixed it
@GregPixel
@GregPixel День назад
​@@lydgiajarvis337 I had to do the same, thanks to both of you
@Mkhl4Sure
@Mkhl4Sure 22 дня назад
Would this also work in excel or jusy Google Sheets
@BetterSheets
@BetterSheets 22 дня назад
I only know Google Sheets
@rahul_bali
@rahul_bali 22 дня назад
that's really cool... can we do this with json data ?
@BetterSheets
@BetterSheets 22 дня назад
Yes
@Bumpy-Man
@Bumpy-Man 23 дня назад
Now if it could jump to today's date in a long list, that would be extra helpful!
@BetterSheets
@BetterSheets 19 дней назад
what if the today's date info could come to you? make a new sheet and use FILTER() formula. bettersheets.co/formulas/filter
@thecressioimpact
@thecressioimpact 23 дня назад
Exactly what we needed! Thank you!
@BetterSheets
@BetterSheets 22 дня назад
What else do you need? Or want?
@thecressioimpact
@thecressioimpact 21 день назад
@@BetterSheets Well we implemented it but the chart is outside of the screensize and there's no ability to scroll so how do we constrain the chart size to the window dimensions? FYI, I've moved the chart to it's own sheet.
@plantahiperactiva
@plantahiperactiva 24 дня назад
It's almost 1 AM and this tutorial saved my night!!
@BetterSheets
@BetterSheets 24 дня назад
Amazing. Let me know what else you need help with.
@dennistucker1153
@dennistucker1153 25 дней назад
Good video. I'm more interested in how to import a flat text file that contains fixed width fields. Especially a file that contain various data types(integers, dates, times, etc.).
@BetterSheets
@BetterSheets 24 дня назад
Do you get an error if you import it? Or can you open in numbers and copy/paste?
@tridsonline
@tridsonline 25 дней назад
👍🏻 It would be Very Helpful if you could also mention in these demos, how to achieve the same thing in the Google Sheets app. For example, in this case: the app doesn't seem to have an import option, so you need to open the CSV file directly from a file explorer into the Google Sheets app. This will close any sheet you were working on, and present the parsed CSV file in a temporary sheet, from which you can select the range you want and copy it to the clipboard. Then open the sheet you want the data in, and paste the clipboard contents there.
@BetterSheets
@BetterSheets 19 дней назад
the app on a phone is far different!
@tridsonline
@tridsonline 19 дней назад
@@BetterSheets Yes, that's my point. There's a large overlap as far as formulas go, but the interfaces differ sometimes to the point of having a feature missing. Or needing a workaround, like in this case. And that's why covering these differences would be helpful.
@andreasgeorgiades8246
@andreasgeorgiades8246 26 дней назад
Can you edit the placeholder text?
@BetterSheets
@BetterSheets 26 дней назад
Just seems like you can turn it off or on.
@jeffryansyahputra3765
@jeffryansyahputra3765 27 дней назад
mantap bang..
@BetterSheets
@BetterSheets 26 дней назад
Thanka
@tridsonline
@tridsonline 27 дней назад
Google Sheets is my only option, given that my primary device is an Android smartphone, and that Excel on Android is 🤮. However, it is extremely frustrating to me how dumbed-down it is on Android .. eg: although it _supports_ named ranges, you can't create or edit them! And to rub salt into that particular wound .. with Google Sheets for Android installed, i don't even have the OPTION of running the browser version (in order to say, create a named range!), as the Android app always takes over. So, many of the juicy features of Sheets are out of reach and that's irritating!
@BetterSheets
@BetterSheets 27 дней назад
Good points all around.
@crj930
@crj930 27 дней назад
didn't work
@BetterSheets
@BetterSheets 27 дней назад
Did you get an error?
@user-ll4wd1cx7x
@user-ll4wd1cx7x 29 дней назад
@BetterSheets Love this! Thanks much for sharing. Do you have any documentation showing countdown in Months, Weeks, Days, and Hours to an event? The months and weeks is what's confusing to me. Many thanks for your time!
@AnoukMusicAddict
@AnoukMusicAddict 29 дней назад
To the point, got it to work in less than 2 mins, thank you, this is the kind of instructional video I like. Well done! Thanks again!
@BetterSheets
@BetterSheets 29 дней назад
Nice! What else do you need help with?
@healthygamerggvods
@healthygamerggvods Месяц назад
you didnt rate it on the basis of privacy/open source - to which i think it is criminally over-rated in
@BetterSheets
@BetterSheets Месяц назад
There is no privacy. And none expected if you share sheets. So maybe its correctly rated ?
@healthygamerggvods
@healthygamerggvods 29 дней назад
@@BetterSheets i think our data should be atleast end to end encrypted for people who want to store confidential information on the sheets? and even for people who want to collaborate and share sheets, i am sure a lot of them wouldnt like any unauthorized person accessing their sheets?
@salahaldeen7924
@salahaldeen7924 Месяц назад
No, but vlookup yes it is overrated
@BetterSheets
@BetterSheets Месяц назад
Nice
@poojaaggarwal6065
@poojaaggarwal6065 Месяц назад
Can You Made video for 5 star rating gor Google Sites To Google Sheet?
@BetterSheets
@BetterSheets Месяц назад
Yes look at the NPS score video on this channel
@martinsandersdesign
@martinsandersdesign Месяц назад
Is there anyway to create tables with app script?
@BetterSheets
@BetterSheets Месяц назад
Nope. Apps script is way behind when it comes to new features.
@igorsantos07
@igorsantos07 Месяц назад
Why start the very first example with a chain of 4 methods, when functions most of the time work with arguments instead of grabbing data from fixed sheet cells? You sure you don't want to scare people as the JS bible did? haha
@BetterSheets
@BetterSheets Месяц назад
Will keep trying to make it simpler. I got a few ideas for very simple apps script videos in the near future.
@RaulFavela-r9b
@RaulFavela-r9b Месяц назад
im having trouble on my end with permission settings, it says I dont have access, but I'm setting who has access as Anyone
@BetterSheets
@BetterSheets Месяц назад
Where does it say you dont have access?
@RaulFavela-r9b
@RaulFavela-r9b Месяц назад
@@BetterSheets it say its on the website, even though I have it so that Anyone can have access. We are using google sites, but even when I embed it into a dummy site it tells me the same thing
@chrisder1814
@chrisder1814 Месяц назад
hello and thank you very much for giving me templates I still have a few questions, is it impossible to add several APIs to my Google sheets this is what I would like to do hello would this API allow me to do image processing? do you also use software like our automation codes like make? and finally I wanted to ask you another question regarding APIs and Google sheet, do you use this method? could I write to you
@BetterSheets
@BetterSheets 19 дней назад
image processing is not that useful in sheets. because images are not in sheets, and so you'd just be using URLs of images online somewhere. and google drive makes it hard to find the actual url of an image saved in a drive folder/file. It's not impossible but it's hard. and yes you can add several apis to a google sheet.
@AshishSrivastava301292
@AshishSrivastava301292 Месяц назад
This was very very useful. Thank You and Tyler
@BetterSheets
@BetterSheets Месяц назад
Anything else you need help with?
@user-pb1ws9uc2h
@user-pb1ws9uc2h Месяц назад
THANK YOU!!!
@BetterSheets
@BetterSheets Месяц назад
Anything else you want to know?
@user-pb1ws9uc2h
@user-pb1ws9uc2h Месяц назад
@@BetterSheets nothing else for now. Thanks!