Bug with "Monthly Analysis" sheet?

Couldn’t find anything in the forum already addressing so I’ll ask here.

Within the “Monthly Analysis” sheet, I have a single expense category that is reporting nothing for the month of January- in both 2024 and 2025 (the two years for which I have transactions). It’s not simply a “$0” showing up in the cell- there are plenty of those for various categories across all the months, it’s nothing- the cell is empty for both Januarys.

I have transactions associated with that category in those months so it isn’t that (it would/should be shown as $0 if so).

The transactions are properly reflected within both the “Spending Trends” and “Category Tracker” sheets, so this is isolated to the “Monthly Analysis” sheet.

Thoughts on what is causing this issue? Bug? Are others similarly impacted?

Thanks.

I would look for clues in the hidden section of the sheet. This might be tough to debug without some screen captures.

Here’s a screen grab of that sheet portion. The first column is January 2024 and looks the same for this year as well.

I can also confirm the total expenses reported for the month include the expenses that aren’t shown in that cell. In other words, the total expenses for that month mirror those shown for that month within the “Spending Trends” and “Category Tracker” sheets.

Okay…I solved it. Somehow the cell font color was selected as white. The value was there, just invisible. I selected black and, voila!, it appears.
I never adjusted any font characteristics so unsure how this occurred. I’ll leave this post up in case others might run into the same “mystery”.

3 Likes

Oh my glad that was realized, it would’ve been an extended mystery otherwise!

Nice work debugging, @HH22.