Find and hide Rows by Grouping Ranges in Google Sheets with Apps Script
To the written tutorial and Starter sheet: https://yagisanatode.com/find-and-hid...
Got a large Google Sheets dataset that you want to hide rows by cell value on?
This tutorial is for you!
Speed up the find and hide process by grouping ranges with Google Apps Script. In this tutorial, we expand on the previous basic function to group adjacent target rows together to send to Google Sheets to be hidden.
00:00 What we will build
01:29 Basic Setup
02:17 IF conditional checks
09:29 Testing the function
In the next tutorial, we look at how to use the Google Sheets Advanced Service API to send all hide instructions as a batch request in Google Apps Script
** Part of the Find and Replace with Apps Script Series **
• Apps Script - Find & Replace in Googl...
** My Site **
https://yagisanatode.com/
** More on Google Apps Script **
https://yagisanatode.com/google-apps-...
** Products **
* Courses *
https://yagisanatode.com/products-cat...
* Google Workspace Tools *
https://yagisanatode.com/products-cat...
* Google Workspace Add-ons *
https://yagisanatode.com/products-cat...
