# Tiller Quick Insights Tab Error

**URL:** <https://community.tiller.com/t/tiller-quick-insights-tab-error/1302>\
**Category:** Google Sheets\
**Tags:** foundation, troubleshooting\
**Created:** [November 18, 2019, 5:21pm UTC](https://community.tiller.com/t/tiller-quick-insights-tab-error/1302 "2019-11-18T17:21:15Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Blake](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/blake/32/7052_2.png) [@Blake](https://community.tiller.com/u/Blake)\
**Post date:** [November 18, 2019, 5:21pm UTC](https://community.tiller.com/t/tiller-quick-insights-tab-error/1302/1 "2019-11-18T17:21:15Z")

</div>

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?

Thanks,

Blake

---

<div class="post-metadata">

**Author:** ![jono](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/jono/32/283_2.png) [@jono](https://community.tiller.com/u/jono)\
**Post date:** [November 18, 2019, 6:36pm UTC](https://community.tiller.com/t/tiller-quick-insights-tab-error/1302/2 "2019-11-18T18:36:00Z")

</div>

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)`

---

<div class="post-metadata">

**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\
**Post date:** [November 18, 2019, 6:37pm UTC](https://community.tiller.com/t/tiller-quick-insights-tab-error/1302/3 "2019-11-18T18:37:56Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\
**Post date:** [November 18, 2019, 6:49pm UTC](https://community.tiller.com/t/tiller-quick-insights-tab-error/1302/4 "2019-11-18T18:49:01Z")

</div>

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 (like `Accounts`).

Randy

---

<div class="post-metadata">

**Author:** ![Blake](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/blake/32/7052_2.png) [@Blake](https://community.tiller.com/u/Blake)\
**Post date:** [November 18, 2019, 8:23pm UTC](https://community.tiller.com/t/tiller-quick-insights-tab-error/1302/5 "2019-11-18T20:23:58Z")

</div>

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