Spreadsheet question:

I would like to hide column K when a certain value is entered in column D. How do I do that?

Can a response on a form also automatically hide a column in a spreadsheet?

I'm trying to help people narrow down choices (column of data) based on responses to questions (cell values). Hiding columns narrows down their choices based on data they enter on spreadsheet or preferably a form.

Thanks,

Doug