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
Automate Row Deletion in Google Sheets with Apps Script
In this post, we'll cover how to remove rows automatically in Google Sheets using Apps Script, ensuring you save time and streamline your spreadsheet management. You're probably already familiar with the manual way of right-clicking and deleting rows, but there's a more efficient way to handle this—automation! Manual versus Semi-Automatic Deletion You may know that you can manually delete rows in Google Sheets by right-clicking and selecting "Delete row." You can even select multiple rows...
How to Count Between 1 and 16 in Google Sheets
A question from the Facebook group "I Love Google Sheets" wants to know how to count numbers between 1 and 16 in a series. So let us break it down and look at the best way to do this. The question was "How can I count the number of values in column B that are between 1 and 16?” 1. Using COUNT. Using the COUNT function will count the numbers in the range. 2. Using COUNTIF. Someone suggested using COUNTIF, however, we have to add a criteria (like >0). But what if we want to count numbe...
How to Tell if Two Cells are the Same or Not the Same in Google Sheets
Determining whether two cells in Google Sheets are equal or not is a common task that can help streamline data analysis and ensure data accuracy. Open up your spreadsheet and follow along with this guide on how to do this using different methods. Are These Two Cells Equal or Not? Two Ways to Use Equal and Two Ways to Use Not Equal We will explore four methods to compare cells: two for checking equality and two for checking inequality. Checking for Equality Method 1: Using the Equal S...
Mastering the Art of Template Creation
An Exclusive Interview with Becky, Owner of The Template Nook 📺Watch the entire 1 hour interview on YouTube In our latest edition of "Sheet Talking," we dove deep into the world of templates and organization with Becky, the owner of The Template Nook. Becky's unique approach to template creation and her dual business ventures, The Template Nook and The Organized CEO, offer valuable insights for anyone looking to streamline their processes and enhance their productivity. Join us as we expl...
Philippines Phone Number Validation: Use of REGEXMATCH in Google Sheets
Every school year thousands of students and teachers’ data were being added to the school database. As someone who was always given the task to narrow down lots of information after the school enrollment, validating students’ data manually is very exhausting. Take this as an example, when you ask students to include the phone numbers of their emergency contact person, there are some instances wherein the declared numbers were invalid due to human error. And the assigned personnel during enr...
How to reference a different Google Spreadsheet in Apps Script?
Transferring Data Between Cells in Different Spreadsheets
One Simple Google Sheets Hack for Better Header Fonts
If you don’t want your spreadsheet to look dull and unprofessional, there’s one trick to make it stand out.
The Double-Edged Sword of Google Sheets Formulas: A Journey Through Frustration and Triumph
A misplaced comma, an incorrect range, or a simple syntax error can render a formula ineffective, leading to hours of troubleshooting. Formula Parse Error, anyone?
Generate Variations of Headlines EASILY in Spreadsheets (with Spintax)
You can now create headline variations and permutations super easily with Spintax. And do it in spreadsheets. More info on Spintax: https://spintax.bettersheets.co/ I just updated the Spintax tool to be able to generate spintax as well as parse it: What is Spintax? Spintax, or spin syntax, is a method used to generate multiple variations of text by enclosing interchangeable parts within curly braces {} and separating them with vertical bars |. For example, {Good|Great} day for a {walk|...
A Decade of Spreadsheet Wisdom
10 years ago Timber was the #1 song... and I was coding in spreadsheets then, just as I am now. Learn from my decade of experience.
The $10 Million Dollar Expense Tracker
YNAB started as a spreadsheet in 2003. Discover 15 more businesses that started as spreadsheets: https://bettersheets.co/started
20 Google Sheets Tips for Bloggers
Through the use of computational tools, like AI and automation functions, you can gain insight from data that was previously too time consuming to extract.