Hello.

As a project, I’m making a spreadsheet to track films and television I’ve watched.

I have a column for the medium, to separate the Television shows from the Movies.

I also have a column for what I’m calling “Source”, as in – where I watched it. Was it a blu-ray or DVD, in the cinema, on a particular streaming platform and so on.

What I’d like to do, is have it so if I select “Television” for the Medium, when I use data validation on the “Source” column, it doesn’t show me options that aren’t valid for it, for example “Cinema”.

Is there a way to nest this sort of requirement into data validation? To make it read columns to know which data types it should take?

Thank you.

​Hello. As a project, I’m making a spreadsheet to track films and television I’ve watched. I have a column for the medium, to separate the Television shows from the Movies. I also have a column for what I’m calling “Source”, as in – where I watched it. Was it a blu-ray or DVD, in the cinema, on a particular streaming platform and so on. What I’d like to do, is have it so if I select “Television” for the Medium, when I use data validation on the “Source” column, it doesn’t show me options that aren’t valid for it, for example “Cinema”. Is there a way to nest this sort of requirement into data validation? To make it read columns to know which data types it should take? Thank you.  Read More

​