Javascript – Hi! I am trying to execute a function to hide rows on my GoogleSheet when the data validation selected is 'Completed'
The options in the dropdown are Completed, In Progress, and Followup. I only want to hide the row when Completed is selected. Is there a way to achieve this? Tried the following function function onEdit(e) { const columns = [3];…