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.
Yup, I feel like there was an update and something went wrong. Can anyone on the Tiller team fix this template?
@jono do you have any insights here?
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
That seemed to be the only issue. Thanks!
1 Like
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!
1 Like