I am working with a spreadsheet and would like to have it automatically hide
rows when a value in one of the column equals zero. I'm pretty sure this is
possible, but I'm not exactly sure how.

Is there any way to do this?