A place to expand your knowledge of Google Workspace, learn new Google Sheets formulas and tricks, and automate the boring stuff with Google Apps Script.
You can select from the 3 main categories below and see what I have been writing lately. In the sidebar, you can select a category item or use the search bar in the top right.
Want some more structured content? Head over to my courses pages for FREE and quality courses to upskill than grey mush 🧠! Need a handy solution for Google Sheets? Check out my products page or my list of Google Workspace Add ons.
Google Apps Script – How to Automatically Generate a Time From a Four Digit 24 hour Time in Google Sheets.
Google Apps Script, Google Sheets On a recent board post, a Google Sheets user wanted to change a four-digit number (for example, 1230) to a time, like 12:30, in the same cell that the item was entered. Unfortunately, the user was not in a position to change the starting values, so they were left with … Continue reading "Google Apps Script – How to Automatically Generate a Time From a Four Digit 24 hour Time in Google Sheets." ...
How to Sort Tabs in Google Sheets with Google Apps Script
Sometimes your Google Sheet tabs can get out of hand. They can be mixed up and confusing to users. It’s often necessary to simply sort them in ascending or descending order. In this tutorial, we will use Google Apps Script to sort tabs in Google Sheets. We’ll also use a handy menu bar to quickly … Continue reading "How to Sort Tabs in Google Sheets with Google Apps Script" ...
Find and Hide Rows in Google Sheets with Apps Script
Using the Spreadsheet App Class’ Text Finder Class to find and hide rows in Google Sheets containing target text in a cell can be a fast way to hide values. In many situations, this may be a faster way to hide rows based on cell value in Google Sheets with Google Apps Script than iterating … Continue reading "Find and Hide Rows in Google Sheets with Apps Script" ...
Find and Select or Format rows in Google Sheets with Apps Script
In this tutorial, we create 3 Google Apps Script functions that are used to: Find and select the row containing the first or last value in a Google Sheets sheet tab. Find and select all rows containing the search value. Format all rows containing the search text. You can grab a copy of the starter … Continue reading "Find and Select or Format rows in Google Sheets with Apps Script" ...
A growing list of free and paid course: