# Hide Setting Not Respected For Savings Column in Savings Budget

**URL:** <https://community.tiller.com/t/hide-setting-not-respected-for-savings-column-in-savings-budget/5778>\
**Category:** Google Sheets\
**Tags:** how-to, troubleshooting\
**Created:** [October 15, 2020, 2:55pm UTC](https://community.tiller.com/t/hide-setting-not-respected-for-savings-column-in-savings-budget/5778 "2020-10-15T14:55:06Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![cculber2](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/cculber2/32/4099_2.png) [@cculber2](https://community.tiller.com/u/cculber2)\
**Post date:** [October 15, 2020, 2:55pm UTC](https://community.tiller.com/t/hide-setting-not-respected-for-savings-column-in-savings-budget/5778/1 "2020-10-15T14:55:06Z")

</div>

Good morning! It’s been a little bit since my last bug fix, but I came across another issue. It appears that the `Savings` column `C` is not respecting the `Hide` flag for categories (and by proxy `Available` column `F`. This became apparent with my hidden Investment category that contains mostly unbalanced transfers. This category is otherwise hidden and values don’t contribute to `Budget` or `Actuals`. Removing the `Savings` flag from the category removed it from the `Savings` column, but that introduces a corresponding offset error.

I was able to address this by concatenating checks in each of the `SUMIF()` functions for an empty string in `Hide From Reports` column `AF7:AF`. Here is my updated formula in `C8`:

> `=ARRAYFORMULA(IF($L8:$L="Category",IF(ISBLANK(VLOOKUP($B8:$B,{$AC$7:$AC,$AO$7:$AO},2,FALSE)),if($BC$6="Savings",VLOOKUP($B8:$B,{$AC$7:$AC,$AJ$7:$AJ},2,FALSE),iferror(1/0)),VLOOKUP($B8:$B,{$AC$7:$AC,$AO$7:$AO},2,FALSE)+if($BC$6="Savings",VLOOKUP($B8:$B,{$AC$7:$AC,$AJ$7:$AJ},2,FALSE),0)),IF($L8:$L="Type",SUMIF($AD$7:$AD&$AF$7:$AF,$B8:$B&"",$AO$7:$AO)+if($BC$6="Savings",SUMIF($AD$7:$AD&$AF$7:$AF,$B8:$B&"",$AJ$7:$AJ),0),IF(ISBLANK($L8:$L),IFERROR(1/0),SUMIF($AD$7:$AD&$AE$7:$AE&$AF$7:$AF,$L8:$L&$B8:$B&"",$AO$7:$AO)+if($BC$6="Savings",SUMIF($AD$7:$AD&$AE$7:$AE&$AF$7:$AF,$L8:$L&$B8:$B&"",$AJ$7:$AJ),0)))))`

After making the change I was able to confirm that removing the `Hide` flag displays the categories as expected.

---

<div class="post-metadata">

**Author:** ![aronos](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/aronos/32/4354_2.png) [@aronos](https://community.tiller.com/u/aronos)\
**Post date:** [October 15, 2020, 4:11pm UTC](https://community.tiller.com/t/hide-setting-not-respected-for-savings-column-in-savings-budget/5778/2 "2020-10-15T16:11:08Z")

</div>

This fixes the huge mismatch between the Savings sum on my Expense type line vs the sum of the categories I mentioned on the other thread.

---

<div class="post-metadata">

**Author:** ![adekunledauda](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/adekunledauda/32/749_2.png) [@adekunledauda](https://community.tiller.com/u/adekunledauda)\
**Post date:** [October 15, 2020, 11:41pm UTC](https://community.tiller.com/t/hide-setting-not-respected-for-savings-column-in-savings-budget/5778/3 "2020-10-15T23:41:30Z")

</div>

`Hide From Reports` column `AF7:AF` . Which report are you talking about please?

---

<div class="post-metadata">

**Author:** ![cculber2](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/cculber2/32/4099_2.png) [@cculber2](https://community.tiller.com/u/cculber2)\
**Post date:** [October 16, 2020, 12:23am UTC](https://community.tiller.com/t/hide-setting-not-respected-for-savings-column-in-savings-budget/5778/4 "2020-10-16T00:23:53Z")

</div>

The `Savings Budget` sheet. That column is in the hidden section.