Index

All Posts

Latest Posts

GWAOw!!!_1_Workbook Statistics by Sourabh Choriaria

GWAOw! 1 – Workbook Statistics by Sourabh Choraria

In this episode of Google Workspace Add On Walkthroughs (GWAOw!), we take a look at Workbook Statistics by Sourabh Choraria. Workbook Statistics is a FREE add-on that allows you to get intimate with all of your Google Sheets stats from your menu bar. You can grab stats on the number of rows, sheet names, pivot … Continue reading "GWAOw! 1 – Workbook Statistics by Sourabh Choraria" ...

Read More
Filtering IMPORTRANGE data in Google Sheets

Filtering IMPORTRANGE data in Google Sheets

Working with IMPORTRANGE data in Google Sheets can be a little tricky. It may feel at times that it does not play by the same rules as when you are building formulas with data in the same Google Sheet. In this tutorial, we’ll go through two approaches to filtering and sorting your IMPORTRANGE data by … Continue reading "Filtering IMPORTRANGE data in Google Sheets" ...

Read More
force subscribe a user in your domain to a Google Calendar with Google Apps Script

How to force subscribe a user in your domain to a Google Calendar with Google Apps Script.

If you have tried to seamlessly subscribe a user to a Google Calendar as part of an automation workflow in Google Apps Script and discovered that all that happens is that the user gets an automated email request to join, and then it is up to them to accept the calendar invitation to add it … Continue reading "How to force subscribe a user in your domain to a Google Calendar with Google Apps Script." ...

Read More
How to delete a Google Sheets Button once it is clicked with Google Apps Script

How to remove a Google Sheets button (drawings) or images connected to a Google Apps Script after the script has been run

There have been a few instances in my work where I need to remove a button (more accurately, a button drawing) or and image from a Google Sheets tab once the associated script has been run. Perhaps we just want the user to run a process on a Google Sheet workbook, just once but not … Continue reading "How to remove a Google Sheets button (drawings) or images connected to a Google Apps Script after the script has been run" ...

Read More

Courses

A growing list of free and paid course:

Social

YoutubeICON
TwitterICON
LinkedinICON

%d bloggers like this: