Hi there! First-time poster, long-time lurker. Tiller has single-handedly changed my life to make sure that I’m approaching my debt in a strategic way, and the Bill Payment Tracker is probably my best friend.
I was wondering if there was a way to increase the number of Upcoming Bill Payments from 20 to any number I choose (like 50). I love the ability to select all the cells for the next x amount of days and see how much I will be paying. Would love to be able to select the next 50 items, or whatever, and plan ahead.
Great question. I’m guessing that you could probably just add rows and extend the formulas for the Bill Payment Tracker to increase the amount of items you can track there. But I’ll let @jono chime in as he’s the brains behind that one
Hi @branadonshutter ,
I’m glad the Bill Payment Tracker is your best friend.
Here’s how you can add more rows to the Upcoming Bill Payment section.
Select any row or multiple rows from row number 17 to 21
The reason you shouldn’t copy any blank rows above row 17 is because there are some hard-coded formulas in the hidden part of the sheet above row 17 that could get messed up if you add rows there.
Then, Insert Rows below to add more rows.
You can do this multiple times to add additional blank rows. Just now above row 17.
Then change the formula in A5. Note where it says “LIMIT 15”. This limits the result to 15 rows. Change the number 15 to the number of rows you now have room for.
The formula in D5 should automatically adjust so the Est Amounts will fill in, if you followed the directions above. You will notice … VLOOKUP(C6:C25, … inside the formula. The C25 reference might show a different number after the C based on how many rows you add. Make sure this range matches the range in Column C starting in C6 to the last row of your Upcoming Bill Payments section. If that’s row 25, the range should be C6:C25 after the VLOOKUP(.
If you want more rows for the Bill History Query section, change the LIMIT 15 in the formula in F6 to the same LIMIT number you used in cell A5 above.
There seems to be a hard limit on the number of bills you can show. I have it showing 143 without issues, but when I add the 144th, it doesn’t bring down the est amount and the category.
Hi @branadonshutter ,
There isn’t any hard limit on the number of bills you can show, but the original sheet does have a limit based on what should work for the vast majority of users.
Adding unlimited rows would hurt the performance for all users even if they weren’t using those rows. So it’s a balance.
But the sheet can be modified to work for as many Bills as you want.
Look at the sheet using the “View” then select “Show formulas”.
The formula in Column E and F in the Bill Setup section, starting in the first Bill row must be filled down for as many rows of Bills that you have.
I’m guessing that you don’t have that formula in row 144.
Try filling it down into as many rows as you need for bills.
Thanks for the feedback, and my apologies as I didn’t explain my question clearly. I don’t need to add more bills, I’m attempting to see more of my upcoming bills in columns A-D. Increasing the limit in A5 and adding additional lines propagates columns A-C, but the numbers in D stop at a certain point.
Yes, D5 would need to expand to the new Upcoming Bill Payments row range.
You could also adjust F6 to increase the “LIMIT” of the QUERY. The original query was limited to 15 rows, but if there are more rows available in the top section, that LIMIT can be increased to the new number of top section rows.
Also don’t change any rows above row 16 because there are hard-coded Date Calculations going down to Z16 to AC 16.
