# Category Schedule template question

**URL:** <https://community.tiller.com/t/category-schedule-template-question/11246>\
**Category:** Google Sheets\
**Tags:** how-to, troubleshooting, tcs-category-schedule\
**Created:** [January 19, 2022, 6:51am UTC](https://community.tiller.com/t/category-schedule-template-question/11246 "2022-01-19T06:51:10Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![dleon6690](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/dleon6690/32/8321_2.png) [@dleon6690](https://community.tiller.com/u/dleon6690)\
**Post date:** [January 19, 2022, 6:51am UTC](https://community.tiller.com/t/category-schedule-template-question/11246/1 "2022-01-19T06:51:10Z")

</div>

I’m having a problem linking the Category Schedule rollup to the Category Sheet. I’m pasting the formula into the monthly category cells in the category sheet but I’m getting a formula parse error.

---

<div class="post-metadata">

**Author:** ![Brad.warren](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/brad.warren/32/896_2.png) [@Brad.warren](https://community.tiller.com/u/Brad.warren)\
**Post date:** [January 19, 2022, 2:43pm UTC](https://community.tiller.com/t/category-schedule-template-question/11246/2 "2022-01-19T14:43:25Z")

</div>

Hi @dleon6690:

I am sorry for the problem you’re having. There could be a few reasons for this.

Take a look at the formula in the cell returning the error and see if it looks exactly like this: (Or, better, copy the formula below and try pasting it in the Jan, 2022 cell of the category line you’re scheduling.)

=iferror(offset(‘Category Schedule’!$G$5,match(offset($A$1,row()-1,match(“Category”,$A$1:$1,0)-1),‘Category Schedule’!$A$5:$A$15,0)-1,match(offset($A$1,0,column()-1),‘Category Schedule’!$G$5:$5,0)-1),0)

When I get an error like that, it is a signal the syntax of the formula is not what is expected.  
Let me know…

---

<div class="post-metadata">

**Author:** ![dleon6690](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/dleon6690/32/8321_2.png) [@dleon6690](https://community.tiller.com/u/dleon6690)\
**Post date:** [January 19, 2022, 6:46pm UTC](https://community.tiller.com/t/category-schedule-template-question/11246/3 "2022-01-19T18:46:06Z")

</div>

Hi Brad,

Thanks for your quick response. I was able to get the formula to work in my Auto & Fuel Category, but it’s not working in the Housing category. For some reason it’s pasting into the next row along with the formatting. I’ve attached screenshots of the two category cells.

---

<div class="post-metadata">

**Author:** ![Brad.warren](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/brad.warren/32/896_2.png) [@Brad.warren](https://community.tiller.com/u/Brad.warren)\
**Post date:** [January 19, 2022, 7:15pm UTC](https://community.tiller.com/t/category-schedule-template-question/11246/4 "2022-01-19T19:15:17Z")

</div>

Hi @dleon6690:

Great work!

I don’t see the screenshots. (Am I missing these? Those would be helpful.) In the meantime, try this: Select a cell with a working formula, right click and copy. Then, moving to another category row with scheduled items, select its Jan, 2020 cell, right-click, and paste special: formula only, and see if that works.

(The good news is the formula is working…just a few tweaks to get it seated into your sheet.)

---

<div class="post-metadata">

**Author:** ![dleon6690](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/dleon6690/32/8321_2.png) [@dleon6690](https://community.tiller.com/u/dleon6690)\
**Post date:** [January 19, 2022, 8:00pm UTC](https://community.tiller.com/t/category-schedule-template-question/11246/5 "2022-01-19T20:00:32Z")

</div>

I got it working just before I read your email. Not sure what I’m doing differently, except when I’m copying the formula I’m using ctrl-c instead of right clicking. Oh, and also I think I’ve been left clicking onto the formula text in the pop-up box before highlighting it. Maybe I’ve been selecting the underlying cell instead of just the formula??

Anyway, thanks for your help!

---

<div class="post-metadata">

**Author:** ![Brad.warren](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/brad.warren/32/896_2.png) [@Brad.warren](https://community.tiller.com/u/Brad.warren)\
**Post date:** [January 19, 2022, 8:14pm UTC](https://community.tiller.com/t/category-schedule-template-question/11246/6 "2022-01-19T20:14:52Z")

</div>

Great work.@dleon6690. Glad you’ve got it working.  
Best!