'How to use Google App Script to automatically hide the entire row based on a cell value [duplicate]

What I want to do is to automatically hide the rows where the status of the task is "Done". Here's the table. It would be great if the hide/unhide actions can be done through a custom menu button.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source