I have a spreadsheet of tasks that I have for myself. When I have completed the task, I mark in column D "Done". I want to make it so that everytime I mark a task as "done" the row gets hidden. This way all that will ever appear are the open items I still have. (But I will have the ability to see those rows hidden if I need to look at old tasks)
Thanks!
Thanks!