Help needed to set up googlesheets dashboard

1

Hi all,

I’m very new to the world of quantified self, and I’m trying to track my health, productivity and finances in one place.
I found this blogpost online https://daviddesouza.co.uk/the-dashboard-of-my-life-2016/ which pointed me to the dashboard he created and shared with the public. https://docs.google.com/spreadsheets/d/1KjRqTm0ZE6nB0rt_XA1pgsWzvJC0JnKpjTXGLxVroiA/edit#gid=1715617727

Unfortunately, my knowledge of sheets is really basic and I can’t fix the #N/A error that isn’t pulling data into the month’s sheet.

Would anyone be able to help me work out what’s going wrong so I can start adding in my own data?
Many thanks in advance,
Andy

2

Not an answer to your question, but I have myself started playing with Google Data Studio to make visualizations from both sheets and google fit data, inspired by this blog post:

https://datasaurus-rex.com/gallery/google-fit-data-studio-dashboard

1 Like
3

I’m not an “expert”, but I have some experience. I clicked the link you provided, and saw numerous #N/A! errors on most of the sheets. I also saw many #DIV/0! errors on the Dashboard sheet. If you specify a particular sheet and cell where you would like to start, I could probably point you in a useful direction. Ultimately, I expect you will find that getting the right data in the right cells (either by copy/paste or by uploading a file) will solve most of the problems all at once.

4

I would use Google Data Studio instead :slight_smile: (It can get data from Google sheets and then you can drag-and-drop a dashboard)

5

I’ve been tracking my finances for ~15 years using one spreadsheet. It supports all I need:

  • monthly credit card bill/expenses tracking
  • currency conversion
  • group purchases (e.g. grocery items)
  • transfers among my accounts
  • balance for each account
  • spending categories
  • monthly averages
1 Like