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...
Watch video Find and hide Rows by Grouping Ranges in Google Sheets with Apps Script online, duration hours minute second in high quality that is uploaded to the channel Yagisanatode -Scott- 08 February 2023. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 1,243 times and liked it 11 visitors.
