Spreadsheet Tips

Resources and inspiration for managing money and life with the flexibility and power of Google Sheets and Microsoft Excel.

All Featured Spreadsheet Templates Money Management Money Mindset Spreadsheet Tips Tiller Tips and Updates Uncategorized

“Service invoked too many times in a short time” in Google Sheets custom formula

Adding a few lines of code to Google Sheets custom formulas can give callers a method to avoid “Service invoked too many times in a short time” errors. Here's the fix.

When “Equals” Doesn’t Really “Equal” in a Spreadsheet

Here's how I solved a problem in a complex spreadsheet that was both very difficult yet simple to find.

A Quick Look at Coda, a New Type of Spreadsheet App

A quick look at Coda, the new spreadsheet format that aspires to blend the “the power of spreadsheets and the utility of applications into a single new canvas."

How to Use IMPORTRANGE to Sync Spreadsheet Transactions

How to use the IMPORTRANGE formula in Google Sheets to categorize transactions in one spreadsheet and share them with a different spreadsheet.

Tags:IMPORTRANGE

The Tool to Split a Transaction Across Multiple Categories in Your Finance Spreadsheet

Sometimes a single transaction doesn’t fit neatly into a single category. The purchase at the grocery store included food for home and also work expenses. The trip to the big box store was for household items but also gifts. Have no fear. We have a tool that makes it easy to split a single transaction into multiple categories.

How Many Cells Are In My Google Sheet?

What should you do when you get that Google error, "There was a problem. This action would increase the number of cells in the workbook above the limit of 2000000 cells.” We've got a handy new add-on that will help.

Tags:Google Sheets Tips

How Can I Automatically Fill a Google Sheets Column With A Formula?

Have you ever wanted to add a new column with a formula to your Transactions sheet that keeps up with the new rows added each day by the Tiller Feed Bot? This week on the blog we share how to use a Google Sheets ArrayFormula to trick out your Transactions sheet.

Tags:formula Google Sheets

Boost Your Finance Management with these Five Google Sheets Tips

We’ve put together five of our favorite Google Sheet features. These powerful tricks will help you fine tune your financial tracking.

Tags:Google Sheets Tips

Using Spreadsheets for Self Employed Tax Preparation

There are many perks to working from home for yourself, but how does that complicate your taxes? In this post we share a strategy for pulling together your tax information to help you share your financial data with an accountant.