Guides for Sheety work

Can I get alerted when a tab name is changed?

Use Apps Script to receive emails whenever there’s a change in your Google Sheet structure Are you an organization with multiple people working on the same Google Sheets file? Then, you might want to know when one of your people changes something in the spreadsheet, whether that be adding or deleting columns, changing the format, or adding tabs. In particular, one of our community members recently asked, “Can I get alerted when a tab name is changed?” To be honest, I didn’t know the answer...

Google Sheets AI Formula

Does Google Sheets have an AI Formula? No but you can add one. Simple use Apps Script to add an AI formula to your sheets. You can use your own AI from Open AI and this comes out to be much cheaper than even $20 a month for ChatGPT at times. Depends on your use of AI. I just updated Better Sheets' AI apps script to use Open AI Omni. Get the full script here. Can I use ChatGPT in Google Sheets? No but you can create ChatGPT in Google Sheets. Let me show you! But I need help with Google...

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.