CODEWITHSUNDEEP
google-sheets
Thomas Evensen
Thomas Evensen

Reputation: 37

Historic data in membership list

I run a membership with < 300 members and keep all info in a google sheet (name, contact info, start date, end date, membership type).

I would like to track changes in membership types (we have 3 different) over time for each member so that I can get statistics with historic data.

My solution as of now is the setup below:

enter image description here

I then punch in the correct memebership type for each member and each month. This creates a huge horizontal sheet and is kinda hard to maintain properly. BUT - I get historic data in my statistics.

Any way to do this cleaner and easier in gSheet?

Upvotes: 0

Views: 62

Answers (1)

ttarchala
ttarchala

Reputation: 4567

I would recommend an approach of typical database normalization here. Keep the list of persons separate, and the list of membership events in its own sheet. This will have the advantage of having to modify things only in 1 place whenever you do things like adding a person or adding a month.

Whenever you need to join the information together, you can then use functionalities like

  • pivot table
  • =VLOOKUP function
  • =QUERY function
  • a custom JavaScript to perform a SQL-like JOIN operation

Upvotes: 1

Related Questions