My Insights tab shows no assets and liabilities (this is at the top of the sheet right above the Transaction Analyzer). Cell R4 has an error message which says…Function indirect parameter 1 value is "Accounts’!F$1:$1’. It is not a valid cell/range reference. What needs to be done to fix this? Th…

Hi @Blake , I think you just need to restore the Insights sheet using Tiller Labs add-on. If you previously restored/updated the Accounts sheet then you’d need to restore all downstream sheets after that so that the formulas get back in sync. Heather

Tiller Quick Insights Tab Error

Google Sheets

Blake November 18, 2019, 8:23pm 5

Boy, you guys are good. Worked like a charm. Thanks, Blake

1 Like

Insights Tab Mostly Empty

Topic		Replies	Views
Balances Tab with #Ref Error Google Sheets	4	532	August 2, 2021
Accidentally deleted Formulas from "Balances" sheet Google Sheets google-sheets , troubleshooting , advice	1	514	July 17, 2020
Insights Tab Mostly Empty Google Sheets troubleshooting	3	611	December 1, 2019
Balances sheet in Foundation broken Google Sheets troubleshooting	2	561	July 18, 2020
How may I correct a reference error? Google Sheets	2	348	August 30, 2020

Tiller Quick Insights Tab Error

Related Topics