I've been tracking my dividends manually in google sheets for like 8 months now, and I had formulas and everything, color coded by month, this whole system going that I felt pretty proud of honestly, but then I added some new positions last week and somehow everything just broke, like all my totals are wrong now and the forecast column is showing errors everywhere and I honestly can't figure out what I messed up even after spending maybe 4 hours trying to fix it.
The worst part is I know there's probably a way simpler way to do this but I'm in too deep now, you know? I just want to see when my dividends are coming and how much I'm getting without needing a computer science degree or something, and my portfolio isn't even that complicated, but trying to track ex dates and payment dates and forecast the next quarter is making me want to give up on the whole dividend strategy thing which is stupid because I actually love getting those payments, I just hate all the admin work that comes with it.
Tell me I'm not the only one who's struggled with this because it's driving me crazy at this point.