Renaming Default Tabs

Google Sheets
1

Hi all. I’m trying out Tille at the moment. I have it linked to an existing Google Spreadsheet that already has a tab named “transactions.”

I would like for tiller to use a sheet other than “transactions”, say, “tiller_transactions”, for the transaction data it pulls from my accounts. Is this possible?

2

No, you’d need to rename your pre-existing tab.

1 Like
3

Thank you @Mark.S for clarifying that for Tiller to work properly the core sheet tabs are identified by their sheet name, changing those 4 sheet tabs does “break” the automation from Tiller.

Those 4 sheet tabs are

  • Transactions
  • Balance History
  • Categories
  • Accounts

Additionally, you can add custom columns to your Tiller Transactions sheet, however, the template column headers need to remain unchanged. The columns are updated by identifying the column header.

-Alice
Tiller Evangelist

Bluesky, Instagram, Facebook, LinkedIn

4

Alice, thanks for the added information. Unless I am missing something, it is not entirely true that one can add custom columns, as Tiller seems to clear any formulas that pre-exist in custom columns (i.e., custom columns in new transaction rows do not include previously entered formulas).

5

Use ARRAYFORMULA in the header row (row 1) of the custom column to get a formula to populate all rows, including new rows.

For example, a commonly added Transactions sheet custom column is the category Group:

={"Group";ARRAYFORMULA(IFERROR(XLOOKUP(INDIRECT("D2:D"),INDIRECT("Categories!A2:A"),INDIRECT("Categories!B2:B"))))}

Where Transactions sheet column D is the Category column.

6

Thanks, Mark. Never used that one before, but it works as expected.

[edit] nevermind, I see now.

1 Like