How I Actually Track Grief Days Without Losing My Mind
I started a grief journal tracker three years ago after my father died. It wasn't supposed to be some spiritual practice. It was supposed to be data. I wanted to know when the bad days came, what triggered them, and whether they were getting better or worse over time. Most people don't keep a tracker because they think journaling is just dumping your feelings on paper and hoping it helps. It doesn't work like that without a system. Here's the one I use, the flaws in it, and how you can set it up in about ten minutes. A Journal Tracker For Grief is simply a structured log where you record daily grief metrics—mood ratings, trigger events, sleep quality, medication, social interaction—and review them weekly or monthly to spot patterns. It's not therapy. It's not replacement for counseling. It's a spreadsheet or notebook with columns that let you see whether things are stabilizing, deteriorating, or fluctuating wildly. The "tracker" part is what separates it from regular journaling. Regular journaling is narrative. A tracker is quantitative enough to reveal trends that your memory will reliably distort. Grief makes you forget how bad last month was. The tracker doesn't forget. I'm going to walk you through building one in Google Sheets because it's free, accessible from your phone, and has conditional formatting that makes spotting spikes almost automatic. You can do it in Notion or even a physical notebook, but the formulas and charts are where the actual value lives. I'll cover that at the end.
The Setup
Create a new Google Sheet. Set up these columns in row 1: Date, Day Number, Sleep Hours, Mood (1-10), Anxiety (1-10), Trigger Event, Social Interaction (0-3), Medication Notes, and Free Form. That's it. Don't add more columns. You'll stop filling it out within two weeks if you do. Day Number is just a running count starting from your first entry. It sounds pointless but it's actually useful for comparing week one to week four without doing calendar math in your head. A trigger event is anything that knocked your mood down more than two points from the previous day. Not everything. Just the notable ones. Grief makes every Tuesday feel significant. It isn't. The tracker will tell you if it is. Use data validation on the Mood and Anxiety columns to lock them between 1 and 10. This sounds bureaucratic and it is. It's also what prevents you from accidentally typing "61" because you were half-asleep and hit the wrong key, which happened to me in week three and threw off my entire average calculation until I spent twenty minutes untangling it.
What to Track and Why Each Field Matters
Sleep Hours is probably the single most predictive variable in your grief trajectory. I know that sounds reductionist. It isn't. Poor sleep amplifies emotional reactivity by a measurable amount, and grief already puts you in a heightened state. If you're sleeping four hours a night, your mood score will be lower regardless of whether you're actually having a hard grief day. Separating sleep-deprived lows from actual grief lows is the whole point of tracking. Social Interaction on a 0-3 scale: 0 is isolated, 1 is brief contact with one person, 2 is a normal social outing, 3 is a high-stimulation social event. High-stimulation events often cause delayed crashes two days later. I didn't understand that until my tracker showed a consistent mood dip on Thursday after a Wednesday family dinner. The pattern was invisible in my head because I felt fine at the time. The data caught it. Medication Notes is where you log any changes to antidepressants, sleep aids, or anti-anxiety meds. Even small dosage shifts show up in your numbers within 48 to 72 hours. If you're working with a prescriber, export your sheet and send it to them. They'll understand it better than you expect. Most of them don't have time to ask detailed questions about your weekly rhythm. The spreadsheet does it for you.
Get the Full Details
Free Form is for whatever doesn't fit the categories. One sentence max. If you're writing paragraphs, you're journaling, not tracking. Keep the formats separate.
Common Mistakes People Make
The biggest one is skipping days and then trying to backfill. Don't. If you missed Tuesday, leave it blank. Backfilling changes your averages in ways that make the data lie to you. A streak of three recorded days followed by a week of absence tells a different story than a week of mostly-recorded days with two guessed entries. The gap is the signal. Grief has irregular patterns. Empty cells are honest. Fabricated cells are not. Another mistake is using a 1-10 scale where 1 means terrible and 10 means great. That's backwards from how most people naturally assign numbers. Use 1 as worst and 10 as best, but be consistent. I switched scales mid-project once and spent a full evening rebalancing my charts because the moving averages inverted. Learned that one the hard way. A third mistake is tracking for three weeks and then stopping because you don't see improvement. Grief doesn't improve linearly. It oscillates. You need at least eight to twelve weeks of data before any trend line means anything. Before that, you're just looking at noise. I wanted to quit at week four. The spreadsheet kept me going because the conditional formatting made the next week's data appear faster than my motivation could fade.
Conditional Formatting That Actually Helps
Apply this rule to your Mood column: if a cell is 3 or below, highlight it red. If it's 7 or above, highlight it green. Nothing else. This creates a visual heatmap as you scroll. After about six weeks, you'll see clusters of red days that correspond to dates you thought were random. Birthdays, anniversaries, certain times of day, weather changes. The pattern emerges without you forcing it. Do the same for Sleep Hours. Anything under five hours in yellow, under four in orange. You'll start seeing that your worst mood days are almost always preceded by a red-sleep night. That correlation is actionable. It doesn't fix the sleep problem, but it tells you which days to protect and which days you can afford to have off.
Weekly Review: The Part Everyone Skips
Every Sunday, spend seven minutes looking at the past seven rows. Don't analyze deeply. Just answer three questions: What was my average mood? What was my average sleep? What triggered the lowest day? Write the answers in a separate tab or a notes field. Do this for four weeks and you'll have enough baseline to notice when something shifts. Without the weekly review, the tracker is just a diary with numbers. The review is where the tracking becomes useful. About five months in, I noticed my mood scores were artificially inflating. I was rating everything a 5 or 6 regardless of how I actually felt. Turns out I'd been using the scale inconsistently. A 5 in January meant something different than a 5 in May because my baseline had shifted. Grief changes your reference point. A bad day in month one might feel like a 3, but the same intensity in month five feels like a 6 because you've adapted. The numbers stayed stable while my actual state was deteriorating. The workaround was to add a "Relative to Baseline" column where I rated each day as significantly worse, slightly worse, same, slightly better, or significantly better than my typical recent state. This anchored the data to my personal experience rather than an arbitrary 1-10 scale. It took extra effort but it corrected the drift. If you hit this problem, you'll recognize it. Your averages look fine and you feel terrible. The relative column will show you the truth.
Exporting and Sharing
Once a month, export the sheet as a PDF. Your future self will appreciate this when you can't remember what October looked like. Therapists and doctors also appreciate it. I had one therapist who told me my tracker was the most useful clinical tool I'd brought to a session. She'd seen hundreds of patients and most of them couldn't describe their weekly patterns beyond "it's complicated." The spreadsheet said it in three lines. If you want a downloadable template, I can share a Google Sheets link that has the columns, data validation, conditional formatting, and weekly review tab already set up. It saves about fifteen minutes of setup and eliminates the risk of breaking the formulas by accident. I've used mine for thirty-one months straight. It's not perfect. It missed a major depressive episode in month eighteen because I stopped logging for eleven days during a hospital stay. Gaps are the weakness of this method. If you go more than ten days without entering data, your trend lines lose meaning and you have to start a new baseline period. There's no workaround for that except staying consistent, which is itself the hardest part.
Journal Tracker For Grief Free Template
I keep a copy here: Grief Tracker Template. It's open to view and you can make a copy. The weekly review tab has simple formulas that calculate your seven-day averages automatically. If you're not comfortable with spreadsheets, the physical notebook version works too. Same columns, same Sunday review habit. You'll just do the math by hand and it will take longer, maybe twenty minutes a week instead of seven. The insight gap between a digital tracker and a paper one is smaller than most people expect. The consistency gap is what actually matters, and consistency depends on how much friction you can tolerate before you quit.
