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 31Aug 31
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 4Jul 4
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 22May 22
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 1May 1
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 25Apr 25
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 18Apr 18
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 9Apr 9
SecretService: Library for Storing Secrets in Google Apps ScriptLeverage SecretService Library for your Google Apps Script projects to securely store secrets.Mar 12Mar 12
Dropdowns in Google Sheets: Complete GuideEverything you need to know about dropdowns in Google SheetsFeb 6Feb 6
FILTER function with OR and complex conditionsFILTER is an indispensable and powerful Google Sheets function that allows you to filter data by multiple criteria. By default, all FILTER…Jan 3Jan 3
