Save Time with Autofill in Google SheetsAutofill is a Google Sheets feature that makes working with data a breeze. This guide will look at what autofill is, how to use it, and…6d ago6d ago
Date and Time in Google Sheets: Complete Guide, Functions, Tips & TricksOne of the most common tasks in Google Sheets is filtering or aggregating data by date and time, counting the number of days, and more…Dec 5, 2024Dec 5, 2024
Multiple Selection Dropdowns in Google SheetsHave you ever wished you could select multiple options in Google Sheets dropdowns? Well, now you can! In August 2024, Google introduced…Aug 31, 2024Aug 31, 2024
Structured Tables in Google SheetsComplete guide to Tables — Google Sheets’ latest new feature: how to create and configure them, that features they offer, their limitationsJul 4, 2024Jul 4, 2024
How to Insert Multiple Rows and Columns in Google SheetsYou can easily insert one row in Google Sheets by right-clicking on the header and choosing Insert 1 row above / below:May 22, 2024May 22, 2024
Access Google Cloud Secret Manager via Google Apps ScriptThere are many ways to store secrets, such as tokens, passwords, and API keys, in Google Apps Script, but they are not created equal. Some…May 1, 2024May 1, 2024
How to Sort by Multiple Columns in Google SheetsYou often need to sort rows by multiple columns simultaneously to review and analyze the data more efficiently. It is easy to do in Google…Apr 25, 2024Apr 25, 2024
7 Ways to Sort Data in Google SheetsSorting data in Google Sheets is a common task that can help organize and analyze it. There are multiple ways to sort data in Google…Apr 18, 2024Apr 18, 2024
How to Preserve Header Row Position During Sorting in Google SheetsIn this post, we will look at a quick lifehack. If you sort data in Google Sheets via the Main Menu -> Data -> Sort ... as well as the…Apr 9, 2024Apr 9, 2024
SecretService: Library for Storing Secrets in Google Apps ScriptLeverage SecretService Library for your Google Apps Script projects to securely store secrets.Mar 12, 2024Mar 12, 2024
