Setting Up Work Journal Spreads For Depression
I built my first tracking spreadsheet around 2019 after I noticed my output collapsed on certain days and I had no idea why. The standard productivity templates don't account for mental health fluctuations, so I had to build something that tracked mood alongside work metrics. What I landed on wasn't elegant, but it actually worked for me over three years. The core structure is simpler than most people make it. You need four columns minimum: Date, Tasks Completed, Mood Rating, and Energy Level. Everything else is optional, but those four fields are where the signal lives. I track mood and energy on a one-to-ten scale because anything more granular like "six and a half" just makes you second-guess yourself every morning. What most people miss is the lag effect. Your energy level on Monday rarely matches your output on Monday. There's usually a two to three day delay between how you feel and when it shows up in your actual work. I added a separate column for "Energy Yesterday" and suddenly the pattern became obvious. Low mood today often means a productivity crash coming Thursday, not today. That insight alone changed how I schedule hard tasks.
I also track sleep hours and whether I exercised, even if it was just walking to the mailbox. Not because these are always causal factors, but because removing variables from your data set creates blind spots. When I stopped logging sleep, I couldn't tell whether a low-output day was depression or just being awake at 2 AM. Having both data points meant I could actually see which one was pulling the weight. Here's the part nobody mentions: the spread gets worse during the exact periods you need it most. Depression makes consistency harder, and if your system requires daily entry at a certain time, you'll skip days during bad stretches and then abandon the whole thing because the gap feels like failure. I solved this by making the daily entry take under two minutes. One line per day, three fields. If I missed Tuesday, I fill it in Wednesday without any explanation field or guilt column. The spreadsheet is not a moral document. Another counter-intuitive thing: I don't review the data weekly. I review it monthly, and I look at averages, not individual days. A single low-mood day with high output is noise. Two weeks of consistently low mood with declining output is a signal. Aggregating to the monthly level reduces the emotional weight of any single entry and actually surfaces the patterns worth responding to.
The limitation is that spreadsheets only capture correlation, not causation. You might find that low mood correlates with missing three deadlines, but that doesn't tell you whether the mood caused the missed deadlines or something else caused both. I learned this the hard way when I spent six weeks convinced that skipping coffee was improving my productivity because my data showed a spike on mornings I didn't drink it. Turns out I'd just slept through the night for the first time in months. The coffee was irrelevant. If your depression is severe enough that even filling out three fields feels impossible, don't use a spreadsheet. Use a voice memo app and dictate one sentence at night. The data quality drops but the compliance rate goes up, and empty rows in a spreadsheet are worse than imperfect voice notes because they reinforce the abandonment cycle. You can find working templates online if you search for mood tracker spreadsheets, but most of them are overbuilt with conditional formatting and dashboards that take longer to maintain than the actual tracking. I started from scratch with a blank Google Sheet every time. It takes about twelve minutes to set up the bare version I described, and zero maintenance afterward beyond the daily entry.
Get the Full Details
