Andrew Kamphey

Google Sheets wizard at BetterSheets.co

Can I get alerted when a tab name is changed?

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

Google Sheets AI Formula

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

Automate Row Deletion in Google Sheets with Apps Script

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

How to Count Between 1 and 16 in Google Sheets

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

How to Tell if Two Cells are the Same or Not the Same in Google Sheets

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?

Mastering the Art of Template Creation

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

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

Better Sheets

Something for everyone to Learn Google Sheets. Includes Google Sheets for Beginners and Advanced Google Sheets Tutorials alike.

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons