google sheets tutorial – cloudHQ Support

Google Sheets tutorial: How to use to automatically create a new sheet with data from rows matching your query

Here are the instructions on how to automatically create separate sheets with data from rows matching your query. The sheet will be created using Google Apps Script and populated using Google Sheets’ FILTER function. This efficient approach ensures that any changes made to the main sheet’s data are automatically reflected in the individual sheets.

Google Sheets tutorial: Create a mirror sheet in that updates automatically

Create a mirror sheet that automatically shows only rows where the “IS DONE” column equals “DONE,” keeping a clean view of completed tasks. You can do this with a simple FILTER formula in the same spreadsheet or use a Google Apps Script (with an optional time-driven trigger) to mirror data across different spreadsheets.

Google Sheets tutorial: How to hide columns in Google Sheets

This short note explains how to hide columns in Google Sheets

Google Sheets tutorial: Using slicer tool

Have you stumbled across Google Sheet’s tool called “Slicer”? This helpful feature lets you filter pivot tables, charts, and tables throughout your spreadsheet. In this step-by-step tutorial, we’ll show you how to leverage each one of these tools. Table of Contents What Is The Slicer Tool in Google Sheets? Adding & Using A Slicer in […]