Apologies if this has been addressed somewhere already – I couldn’t come up with anything when I searched. I’m having an issue where when I add a transaction manually (using the Labs add-on), it fills in the type of transaction in the Type column, which creates an error for the array formula that’s…

I noticed the same thing the other day, definitely a ‘bug’ that needs fixing.

Hi @mlux : I don’t use the Type column and don’t have it in my Transactions sheet, but when I added the column just now and then manually added a transaction, the column populated with the account type without an error. Have you added a custom array formula to your Type column?

Hi Brad, The Type column was added to my spreadsheet as part of the Business Dashboard. It’s possible I tweaked the array formula and forgot, but I think it was configured that way from the start, especially since @jpfieber is having the same issue. I’ll tag this post so it’s clearer that it’s a c…

I don’t have the Business Dashboard, so there must be more than one ‘Solution’ that uses that column. My ‘Type’ column has the formula: =ARRAYFORMULA(IF($C:$C = "Category", "Type", IFERROR(VLOOKUP($C:$C,Categories!$A$2:$C,3, TRUE),"")))

Hi @jpfieber and @mlux : I hope to not confuse this further. @jpfieber , I added a column to my transaction sheet and then put your formula in the top cell. After I corrected the references to my Category column, (in my Transactions sheet, the Category column is G so I changed all of the Cs to Gs) it…

Just to be clear, @Brad.warren , when you say “it works as expected” do you mean you were able to manually add a transaction with the Labs add-on and it didn’t obstruct the array formula in the Type column?

My Categories sheet is standard, with the columns as you list. The formula works fine unless something is manually entered into it. If something is entered into it, as the “Manual Transaction” tool seems to do, then the column header gives a #REF! error, (Array result was not expanded because it wou…

Good question and feedback, @mlux and @jpfieber . It works as expected when I add a line manually then type in the data. If I use the Labs Add-on, it, in fact, returns the error that you are seeing. As you said, this appears to be a timing issue with the execution of the rules, where the data in the…

Got it, @jpfieber and @mlux : Apologies for my fumbling around here. When the Type column is renamed, “Category Type,” the formula works for transactions added by the Labs Add-on. Evidently, a column named, “Type” is scripted in the Add-on to return the Account Type, not the Category Type you’re se…

I just changed the column from ‘Type’ to ‘Category Type’ in the formula, and added a manual task through the add-on, and it worked as expected. Nothing was inserted into the Category Type column, which was then automatically filled in by the formula, as it should be. Thanks!

Manually Added transactions - #REF error on type column - #15 by randy - Google Sheets

Topic		Replies	Views	Activity
Adding a Category Type Column to the Transactions Sheet gSheets Templates	11	735	December 6, 2023
How to manually add a transaction if the account doesn't exist? Ask Anything	10	668	March 8, 2022
Adding New Columns On The Transaction Tab Automatically Google Sheets	5	705	December 23, 2020
How can I add Expense Type from Categories Sheet to my Transactions Sheet Google Sheets	1	584	April 2, 2021
Column gone wrong Google Sheets	4	360	December 18, 2023

Adding a Category Type Column to the Transactions Sheet

gSheets Templates

11

735

December 6, 2023

How to manually add a transaction if the account doesn't exist?

Ask Anything

10

668

March 8, 2022

Adding New Columns On The Transaction Tab Automatically

Google Sheets

5

705

December 23, 2020

How can I add Expense Type from Categories Sheet to my Transactions Sheet

Google Sheets

1

584

April 2, 2021

Column gone wrong

Google Sheets

4

360

December 18, 2023

Manually Added transactions - #REF error on type column

Related topics