Transaction splitter issue / Saved Splits

:wave:

Hello - I am new to Tiller and Google Sheets.
I have however managed to get the Saved Splits into my Google Sheet.

My problem is that in the Saved Splits sheet, when I go to pick a category, it just says loading.
Apparently I have done something wrong and I am hoping someone can help me fix it.
I do have the required columns in my Transactions sheet.

In my Transactions Sheet - Category Column is “D”. In Saved Splits Sheet - Category Column is “C”. Is this my problem?

Thanks for any advice! :slight_smile:

That is an interesting problem, @Ramona.

After drawing the Transaction Splitter sidebar pane, the TMF add-on tries to load your categories from the Categories sheet. It sounds like this process isn’t working for you.

Here are a few things to look into and try:

  • If you go to the “Add Manual Transaction” pane in TMF, do your categories load into the dropdown?
  • Is your categories sheet called exactly “Categories”? (Pay attention to whitespace characters on either side.)
  • Is there a column in your Categories sheet called exactly “Category”? (Pay attention to whitespace characters on either side.)
  • Can you respond with a screenshot of the first few rows of your Categories and Saved Splits sheets?

The horizontal position of the columns shouldn’t matter too much so long as the header names are correct and in the first row.

Hi @randy, Thanks for getting back to me.

Add Manual Transaction - Categories load into dropdown fine
Categories Sheet - Is exactly called Categories
Categories Sheet Column - Is Exactly Category


Oh interesting… I thought you meant it was “loading…” in our add-on.

What happens if you just rebuild the data validation? Can you clear the data validation in the Saved Splits sheet (Category column) and then recreate the reference in that sheet to column A in the Categories sheet.

Can you let me know if that works?

Sorry @randy for the delay.

I would love to do as you suggested, however I am new to google sheets and have no idea how to do it.
I deleted the sheet and tried again, but it still didn’t work. I must be doing something wrong regarding the instructions.

I think I figured out how to get the existing data validation. This is what is says

Hi @Ramona,

Looks like you have it working now, the categories are showing. Is the loading… issue resolved as well?

Hello @tom thanks for the reply

Unfortunately I haven’t resolved the issue of the categories loading.
The screen shot above was when I first downloaded the saved split sheet.

  • I have paycheck as a category
  • I don’t have any of the other categories though (the red triangle)

I posted it to show the data validation rules for the column (Far Right).
To see if someone can tell me if the validation rules are correct.