I'm using a spreadsheet with 3 columns: Name, InvoiceId and Payment status (Paid?). The first step is to open your spreadsheet or create a new one. Step 4 - Create a custom menu to make it easy for users to run these functions Step 3 - Create a function to show all rows
Step 2 - Create a function to filter rows based on the value in a specific column Step 1 - Create your Google Sheets spreadsheet 4 steps to hide rows based on cell value in Google Sheets using Apps Script
#How to show hide in word 2017 series#
Note: If you've never programmed using Apps Script before, I've written a series of tutorials to help you learn the basic concepts. Reading data from a range in Google Sheets This tutorial assumes that you're familiar with the following concepts:īasics of working with Google Apps Script Your browser does not support HTML5 video. Selecting Show all rows will unhide all rows in your spreadsheet. Selecting Filter rows will hide all rows that are marked as paid. We will build a custom menu called "Custom Filter" with two menu items: (1) Filter rows, and (2) Show all rows.
#How to show hide in word 2017 how to#
In this tutorial, I will show you how to make this workflow more seamless by using Apps Script. You have to select the filter settings and then select Ok each time you want the filter to process new changes in your spreadsheet. In the video above, despite setting up a filter, it isn't easy to hide rows that are newly marked as paid. However, the disadvantage of these methods is that it can be cumbersome to hide or unhide rows as you make changes to your sheet. For e.g., you can create a filter or a filter view in your sheet.
There are a few different ways to achieve this. If you do use checkboxes and you forget to specify custom values, please note that by default, checkboxes have TRUE and FALSE values associated with their checked and unchecked states respectively. The checkbox is effectively doing the same thing behind the scenes. If you do not know how to use checkboxes or if you do not want to use them, you can simply enter Y or N in each row for payment status.