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

Can you share the formula in R4? Mine is: =QUERY(indirect("Accounts!$"&P29&"$2:$"&P40&"$101"),"SELECT "&P30&", "&P31&", "&P38&", "&P33&" WHERE "&P40&" <> 'Hide'",-1)

Sorry, @blake . The restore process with cascading downstream dependencies isn’t well supported by Google’s API. We are trying to find solutions to make this more seamless… but, for now, as @heather notes, the best solution is just to restore the downstream templates after updating anything upstream …

Tiller Quick Insights Tab Error

Spreadsheets Google Sheets

Blake November 18, 2019, 8:23pm 5

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

Insights Tab Mostly Empty

Topic		Replies	Views
Feedback & Bugs for Tiller Labs Add-on Google Sheets	59	5548	May 5, 2020
Insights tab not working Google Sheets troubleshooting	5	273	March 8, 2024
Tiller Quick Insights tab Ask Anything	2	153	April 22, 2024
Insights Tab Mostly Empty Google Sheets troubleshooting	3	701	December 1, 2019
Accounts sheet update killed all my account links, i think Google Sheets foundation , troubleshooting	17	2000	February 20, 2020

Tiller Quick Insights Tab Error

Related topics