Guides for Sheety work
Tips & tricks? Who needs tips and tricks? You just want your sheet to do something it isn't doing now. These aren't just hot tips. They're the long guides I write when a problem is too annoying to just say "here's a quick fix."
Free tutorials on YouTube
Step-by-step videos on Google Sheets. All free at youtube.com/bettersheets.
Watch on YouTube
Latest posts
Can ChatGPT Automate Spreadsheets?
Automate Google Sheets! Learn to create custom add-ons, decipher code, and automate daily tasks using Apps Scripts. Optimize your spreadsheets.
Think Like a Programmer | Develop The Mindset of an Apps Script Coder
•Don't memorize. Know where the information is •Read the documentation •Try things. Go for it! •Seek out errors.
Automate Google Sheets without Apps Script, without Zapier
I've been doing a lot in spreadsheet automation using Apps Script. But I wanted to go back to some formulas that I think feel like magic. They make me feel like a wizard without having to code.
Google Sheets Error: Unknown Range Name and How to Fix it
A user asked me about an error, which is the "Unknown Range Name." By the time you’ve read this tutorial, you’ll know how to fix this error. What is the Unknown Range Name error? It’s an error that you get when the value that was entered does not have the correct format. Another cause of this error is when the value that was entered is outside the expected range. As you can see right here, there’s the "Unknown Range Name" error. Now, what that means is that there is supposed to be ranges ...
Most Common Errors and How To Handle Them in Google Sheets
Most Common Errors and How To Handle Them in Google Sheets #N/A error #REF! error #NAME? error #DIV/0! Error #VALUE! Error #NUM! error #NULL! error
Organize Your Data! - Build a Kanban Board / Trello Board
Effortlessly organize tasks using Google Sheets! Learn impressive formulas, create Kanban/Trello boards, and optimize your life and workflow.
Every Locale Listed in Google Sheets and a Tool to Save Your Sanity
If you live in a country that is not well represented with blog posts or someone makes a blog post about a Google Sheets issue, they create a Google Sheet formula and then you copy and paste it into your sheet and it has the wrong delimiter. How do you resolve that?
Make It Easier For Others To Use Your Google Sheets
In this tutorial, we're going to orient users better in Google Sheets. We want to help not just ourselves but also anyone who’s going to use a spreadsheet that we have created.
Ken Asks Can We Add Star Ratings in Google Sheets?
Learn to use data validation, emojis, and various scripts for a captivating visual representation of data. Explore easy ways to add star ratings in Google Sheets.
This Week in Better Sheets - Feb 12th, 2023
Make your sheets better 1% every day. Google Sheets can be boring. It can get complicated. But it doesn’t have to be. Here at Better Sheets, we don’t just make them better. We make them more fun, too.
Sell Daily – Unleash the power of language with this game-changing Google Sheets template
Sell Daily – 366 words that sell. Get access to absolutely unique 366 words that will help you sell. No duplicates!
What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users
Make your data tasks simpler & efficient. Discover the power of automation in Google Sheets with a comprehensive guide that covers everything from triggers to scripts.