Insights not showing transactions

Hi there,

I’m having a problem with insights sheets.

I don’t have errors anymore, but for a period, I don’t have any top transactions and the field range is not fullfilled.

Can you help me?

Best Regards,

I would try a couple of things.

On your Transactions Sheet, check your column names. Typically I find when Insights goes blank for me, I have accidentally typed over one of the Column names.

Also, I would try using “This Year” for the Period on the Insights Sheet. It’s the same as your custom dates.

Hi,

I validated the columns. The names are correct and changed to this year and nothing :frowning:
Thanks

From your other thread, it seems like your issues are locale related - did you try changing the locale per @KyleT suggestion?

My locale is Portugal. Everything is working, except the top 10 transactions and the transactions range.

Best Regards,

Our templates only support the locale spreadsheet setting as United States. I recommend setting it back to US locale. If that doesn’t fix it try restoring the sheet using the Tiller Money Feeds add-on > Manage Solutions option.

The restore of template solved :wink:

Thank you

Hi @ricardosmenezes - I had a similar problem which came about when I archived some transactions. I had created a sheet called “Transactions_old”. When I did that, the formulas in Rows 10-14 automatically updated to reference the “Transactions_old” sheet while the Range in Row15 remained pointing to the normal Transactions sheet. Cell P15 is coded to use the header description from O9 so it will always refer to “Transactions”. That is okay, but if the formulas in the other rows shift to another sheet, a mismatch occurs and, at least for me, those same sections went blank. You might want to double-check that the formulas in cells P10-P14 are also referring to the “Transactions” sheet, the same as Cell P15.

1 Like