# Tiller Labs Roundup: 12/19/19 - Monthly Analysis template **URL:** \ **Category:** News from Tiller\ **Tags:** tcs-roundup\ **Created:** [December 19, 2019, 9:53pm UTC](https://community.tiller.com/t/tiller-labs-roundup-12-19-19-monthly-analysis-template/1703 "2019-12-19T21:53:58Z")\ **Posts on this page:** 5\ **Page:** 1
**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:** [December 19, 2019, 9:53pm UTC](https://community.tiller.com/t/tiller-labs-roundup-12-19-19-monthly-analysis-template/1703/1 "2019-12-19T21:53:58Z")
In our Tiller Labs Roundups, we’ll keep you updated on our latest features and sheets. Our Tiller Labs team is working to keep you efficient, inspired, and enabled with financial templates, tools and workflows. We recently published a new Monthly Analysis sheet that you can get using the [Tiller Labs add-on](https://community.tiller.com/t/how-to-use-the-tiller-labs-add-on/67). ### [Monthly Analysis template](https://community.tiller.com/t/add-a-monthly-analysis-sheet-to-your-foundation-template/1585) We built this template based on a frequent request to our customer-success team. Per @krista, _“We’ve been hearing from folks who wanted an easy way to view spending totals across their categories without building a pivot table. The new Monthly Analysis sheet gives you the power to view those actual spending values, budget values, or the difference between them with just a few clicks.”_ One section of this new sheet shows Month-to-Month percentage and dollar changes for categories, groups, or total income or expenses. Another section provides a yearly chart of the Budget vs Actual amounts for your selection. ![Screen Shot 2019-12-11 at 9.30.48 AM](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/2X/5/5b5819e5c001f480fece6b71de87bb3d03a69ca3.png) Finally, there’s a section at the bottom showing monthly actual, budget, or available amounts over the course of a year for each of your Categories and Groups. [Here’s a post](https://community.tiller.com/t/add-a-monthly-analysis-sheet-to-your-foundation-template/1585) that gives the details on how to add and use the new sheet. Happy Holidays, Jon _P.S. To stay up to date on the latest features and additions to the [Tiller Labs add-on](https://community.tiller.com/t/how-to-use-the-tiller-labs-add-on/67), consider following the [`labs-roundup` tag](https://community.tiller.com/tags/labs-roundup)— also available via [RSS](https://community.tiller.com/tags/labs-roundup.rss)._ ---
**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:** [December 19, 2019, 11:58pm UTC](https://community.tiller.com/t/tiller-labs-roundup-12-19-19-monthly-analysis-template/1703/2 "2019-12-19T23:58:10Z")
---
**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:** [December 27, 2019, 5:09am UTC](https://community.tiller.com/t/tiller-labs-roundup-12-19-19-monthly-analysis-template/1703/3 "2019-12-27T05:09:22Z")
In cell b8/c8, i get an error that says input must fall within specified range. ---
**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:** [December 27, 2019, 7:46pm UTC](https://community.tiller.com/t/tiller-labs-roundup-12-19-19-monthly-analysis-template/1703/4 "2019-12-27T19:46:25Z")
Hi @Blake, The B8/C8 value is determined by whether you select All, Group, or Category in B7. If you select Group in B7, then B8 will give you the group options. But if you change B7 then to Categories, you might see the error you mention above. If you had selected a Group in B7, that Group may longer appear in the list of Categories (unless you have a Group and Category with the same name.) When you get that error, check out what the options are in the dropdown. I’m pretty sure that’s what’s going on. Using formulas, I don’t think there is a way to over-write a cell but also make that cell a user selected option. Jon ---
**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:** [December 27, 2019, 11:55pm UTC](https://community.tiller.com/t/tiller-labs-roundup-12-19-19-monthly-analysis-template/1703/5 "2019-12-27T23:55:08Z")
I see now. I was not clicking on the arrow but when I do it gives me the categories and then the error goes away when I select a category. Thanks, Blake