# Holiday gift planner issue

**URL:** <https://community.tiller.com/t/holiday-gift-planner-issue/6067>\
**Category:** Google Sheets\
**Tags:** tcs-gift-planner\
**Created:** [November 9, 2020, 8:03pm UTC](https://community.tiller.com/t/holiday-gift-planner-issue/6067 "2020-11-09T20:03:47Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![taylor](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/taylor/32/310_2.png) [@taylor](https://community.tiller.com/u/taylor)\
**Post date:** [November 9, 2020, 8:03pm UTC](https://community.tiller.com/t/holiday-gift-planner-issue/6067/1 "2020-11-09T20:03:47Z")

</div>

Hi! I just started to set up the Holiday Gift Planner template, and it seems a little off. The `Spent` amount is a sum of the `Budget Available` column.

---

<div class="post-metadata">

**Author:** ![tilleruser](https://avatars.discourse-cdn.com/v4/letter/t/bcef8e/32.png) [@tilleruser](https://community.tiller.com/u/tilleruser)\
**Post date:** [November 16, 2020, 12:12am UTC](https://community.tiller.com/t/holiday-gift-planner-issue/6067/2 "2020-11-16T00:12:49Z")

</div>

Yup, I feel like there was an update and something went wrong. Can anyone on the Tiller team fix this template?

---

<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 19, 2020, 4:19pm UTC](https://community.tiller.com/t/holiday-gift-planner-issue/6067/3 "2020-11-19T16:19:02Z")

</div>

@jono do you have any insights here?

---

<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 19, 2020, 9:45pm UTC](https://community.tiller.com/t/holiday-gift-planner-issue/6067/4 "2020-11-19T21:45:14Z")

</div>

There is a formula error for the Spent total. Perhaps there was an update that caused this.

The formula in E8 is `=SUM(F11:F30)`  
It should be `=SUM(E11:E30)`

The template has been updated with the correct formula. It is available now in the Tiller Money Labs add-on. Update to Version 1.02.

Were there any other issues with the sheet? I did some testing and didn’t see any problems.

Thanks,  
Jon

---

<div class="post-metadata">

**Author:** ![tilleruser](https://avatars.discourse-cdn.com/v4/letter/t/bcef8e/32.png) [@tilleruser](https://community.tiller.com/u/tilleruser)\
**Post date:** [November 20, 2020, 3:58pm UTC](https://community.tiller.com/t/holiday-gift-planner-issue/6067/5 "2020-11-20T15:58:39Z")

</div>

That seemed to be the only issue. Thanks!

---

<div class="post-metadata">

**Author:** ![mlux](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/mlux/32/1153_2.png) [@mlux](https://community.tiller.com/u/mlux)\
**Post date:** [December 3, 2020, 5:36pm UTC](https://community.tiller.com/t/holiday-gift-planner-issue/6067/6 "2020-12-03T17:36:20Z")

</div>

Not sure whether to post here or start a new topic.

I ran into an issue because my “Tags” column is column AC on my Transactions sheet (I know, I know. I have so many custom columns.)

**The fix:** I edited the formulas in K2:K7 to use, e.g. `regexextract(address(1,J2),"[A-Z]+"))` instead of `CHAR(64,J2)`, making it more robust for column counts above 26.

Hope this is helpful for someone else!