Hi!
I am trying to setup a spreadsheet to share a list of common movies with my wife.
I’ve had a couple of ideas on how best to do it, but I wanted some advice on which is the “better” solution that allows for more customization, or ease of use.
Idea 1:
Create 2 tables. 1 for each partner, we both put in the movies we like (IMDB URL and Movie name)
Create a helper table, that lists all movies in both.
Create a summary table from helper table that lists all movies in helper table.
Shown in “Movies for both” table.
Pros:
We each have our own sheet
Anything we do in our own sheet does not affect the other partner’s list.
Cons:
Marking movies watched, must be done separately.
Duplicate data
Inefficient(?)
Idea 2:
Create 2 tables. 1 for each partner, we both put in the movies we like (IMDB URL and Movie name)
Create a summary table from one of the lists.
Filter based on that summary table.
Pros:
More filtering/sorting available in movies for both.
Cons:
List is only showing 1 person’s list, only highlighting what’s also in the other list.
Duplicate list.
Shown in “Movies for both v2” table.
Idea 3:
Create 1 movie table, with a column to label who’s movie it is.
Filter different views based on that 1 table.
Pros:
1 table. More efficient.
Cons:
Manually label each movie for who added it
Can end up with a lot of empty rows if using the filtered table to add movies.
I’d love to hear thoughts on what’s best on how to make this, and if my ideas are silly, or if they’re on the right track for the best way to do this.
I’d want a way in which my wife and I can copy/paste the IMDB Link, with each of the movies we each like in separate lists, or marked with our name so we know.
Then a combined list showing what we both like, that way we have a nice list of movies we both are interested in watching.
Thanks for reading, would love to hear some feedback!
Have a great week.