# Split transaction workflow shows "no category column" in category dropdown **URL:** \ **Category:** Google Sheets\ **Tags:** tcs-splitter\ **Created:** [July 5, 2020, 6:16pm UTC](https://community.tiller.com/t/split-transaction-workflow-shows-no-category-column-in-category-dropdown/4660 "2020-07-05T18:16:50Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![larry.cocarr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/larry.cocarr/32/2144_2.png) [@larry.cocarr](https://community.tiller.com/u/larry.cocarr)\ **Post date:** [July 5, 2020, 6:16pm UTC](https://community.tiller.com/t/split-transaction-workflow-shows-no-category-column-in-category-dropdown/4660/1 "2020-07-05T18:16:50Z")
I have a question about the Splitter workflow from Tiller Money Labs. ---
**Author:** ![warren](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/warren/32/1191_2.png) [@warren](https://community.tiller.com/u/warren)\ **Post date:** [July 6, 2020, 3:01pm UTC](https://community.tiller.com/t/split-transaction-workflow-shows-no-category-column-in-category-dropdown/4660/2 "2020-07-06T15:01:27Z")
Hi Larry, Whats your question? Here’s a guide on using the Splitter Tool. > [@Docs: Transaction Splitter](https://community.tiller.com/t/how-to-use-the-transaction-splitter-from-tiller-labs/1586): > > Overview Sometimes it’s nice to break up a single transaction into multiple categories. You get cashback at the grocery checkout and want to split the transaction between your Grocery and Cash categories You make a large purchase on Amazon and want to bucket the computer, dog food and bedding purchases by category (rather than having just one large, ambiguous line item) You consolidate a shared dinner with friends onto your credit card and receive cash to cover… ---
**Author:** ![larry.cocarr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/larry.cocarr/32/2144_2.png) [@larry.cocarr](https://community.tiller.com/u/larry.cocarr)\ **Post date:** [July 6, 2020, 5:13pm UTC](https://community.tiller.com/t/split-transaction-workflow-shows-no-category-column-in-category-dropdown/4660/3 "2020-07-06T17:13:47Z")
Thanks for reaching out. I’ve successfully used Split Transaction for some time - but it is not working for me now. Tiller Money Labs, Tools, Split Transactions. In the lightly greyed area are the words: Original Transaction “No Category Column” … and it will not let me get past “No Category Column” to select the category I need to use. The Transaction sheet displays the correct category. What must I do to regain access to the splitter and enter needed categories? I can send more details, or a screenshot if helpful. Thanks. Larry Carr ---
**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\ **Post date:** [July 6, 2020, 7:12pm UTC](https://community.tiller.com/t/split-transaction-workflow-shows-no-category-column-in-category-dropdown/4660/4 "2020-07-06T19:12:27Z")
Hi @larry.cocarr, I think you just need to make sure that the word “Category” is in the Category column in row 1 on the Transactions sheet or if there is no Category column add one. ---
**Author:** ![larry.cocarr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/larry.cocarr/32/2144_2.png) [@larry.cocarr](https://community.tiller.com/u/larry.cocarr)\ **Post date:** [July 6, 2020, 8:51pm UTC](https://community.tiller.com/t/split-transaction-workflow-shows-no-category-column-in-category-dropdown/4660/5 "2020-07-06T20:51:20Z")
Screenshot showing the Transaction Sheet and a Split Transaction option from Tiller Money Labs, attached. Transaction sheet, the column heading for column D is “Category”. Line 6 on this sheet shows a net social security income entry pulled from my checking acct ($1429) into this Tiller sheet. But I need a split transaction so gross social security income will be $1573 less $144.60 for the amount of medical premium withheld by social security administration. Split transaction module shown on the screenshot says: Original Transaction gas “ **No Category Column** ”. The up-down arrows are frozen. They will not allow me to select an alternative to “No Category Column”. Obviously I am missing a step along the way. What am I doing wrong? Larry Carr ![Tiller, Split Trans.png](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/2X/c/c84792e037cb5cd278468d3cde4302453f65c2f1.png) ---
**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\ **Post date:** [July 7, 2020, 1:15pm UTC](https://community.tiller.com/t/split-transaction-workflow-shows-no-category-column-in-category-dropdown/4660/6 "2020-07-07T13:15:55Z")
@larry.cocarr, I can’t reproduce this. If you try retying “Category” in that column in row 1 and then re-launch the Labs add-on and try again? ---
**Author:** ![larry.cocarr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/larry.cocarr/32/2144_2.png) [@larry.cocarr](https://community.tiller.com/u/larry.cocarr)\ **Post date:** [July 7, 2020, 8:07pm UTC](https://community.tiller.com/t/split-transaction-workflow-shows-no-category-column-in-category-dropdown/4660/7 "2020-07-07T20:07:17Z")
Following your suggestion. Retyped “Category” line 1, column D. Signed out of Tiller, came back in, back to Add-Ons, etc, and same as before. In Tiller Labs, Split Transaction, it still says Original Transaction “No Category Column” and the up/down arrows are frozen. To repeat, yes in Transactions, I deleted the heading “Category”, line 1 Column D, and then retyped the word Category. ---
**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\ **Post date:** [July 7, 2020, 8:24pm UTC](https://community.tiller.com/t/split-transaction-workflow-shows-no-category-column-in-category-dropdown/4660/8 "2020-07-07T20:24:46Z")
@randy do you have any ideas? ---
**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\ **Post date:** [July 9, 2020, 3:56pm UTC](https://community.tiller.com/t/split-transaction-workflow-shows-no-category-column-in-category-dropdown/4660/9 "2020-07-09T15:56:13Z")
This is a puzzling, @larry.cocarr. The most likely issue would be, as @heather notes, that either the sheet name or column name somehow isn’t an exact text match with what the add-on is expecting. The most likely culprit would be a typo or stray space in the sheet name “Transactions” or column name “Category”. I hate to keep asking the same question, but are you certain that neither has an extra space? If you can confirm that both text strings match exactly and you’re still having issues, I can review the code in detail and see if anything else could cause this problem. Sorry for this issue. We haven’t seen it before. Randy ---
**Author:** ![larry.cocarr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/larry.cocarr/32/2144_2.png) [@larry.cocarr](https://community.tiller.com/u/larry.cocarr)\ **Post date:** [July 9, 2020, 9:11pm UTC](https://community.tiller.com/t/split-transaction-workflow-shows-no-category-column-in-category-dropdown/4660/10 "2020-07-09T21:11:54Z")
I agree with every one of your comments knowing that an ever so slight deviation can create problems. I too am stymied on this one. I have deleted the word “Category” from Transactions, closed Tiller, reopened Tiller, reentered “Category” to column D (with no extra spaces), gone back to the Split transactions and this error message remains: Description Ssa Treas 310 Xxsoc Sec \* Ssa Original Transaction I’ve even done the same with the description in column C, line 11 (removed it, closed Tiller, reopened, etc.). It is obvious to me there remains an error someplace and I may be the cause. Unfortunately, I do not know what the error is or how to correct it. Larry ---
**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\ **Post date:** [July 10, 2020, 1:38pm UTC](https://community.tiller.com/t/split-transaction-workflow-shows-no-category-column-in-category-dropdown/4660/11 "2020-07-10T13:38:20Z")
@larry.cocarr, do you get this issue on _any_ transaction you try to split or only this one specifically? ---
**Author:** ![larry.cocarr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/larry.cocarr/32/2144_2.png) [@larry.cocarr](https://community.tiller.com/u/larry.cocarr)\ **Post date:** [July 10, 2020, 2:44pm UTC](https://community.tiller.com/t/split-transaction-workflow-shows-no-category-column-in-category-dropdown/4660/13 "2020-07-10T14:44:29Z")
This one, specifically. A similar but separate transaction on 6.23.20 worked fine. This one, dated 7.01.20 is the problem. ---
**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\ **Post date:** [July 13, 2020, 2:36pm UTC](https://community.tiller.com/t/split-transaction-workflow-shows-no-category-column-in-category-dropdown/4660/16 "2020-07-13T14:36:37Z")
Larry, The `"No Category Column"` error message makes it look like the code couldn’t find the `Category` column in the `Transactions` sheet, but the issue actually that it can’t find the `Category` column in the `Categories` sheet (where it pulls the category list for the splitter dropdown from). In your sheet, it looks like you accidentally renamed the `Category` column in the `Categories` sheet to `"35"`. Changing this to `"Category"` will fix the splitter. Thanks for your patience as we sorted through this issue. ---
**Author:** ![larry.cocarr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/larry.cocarr/32/2144_2.png) [@larry.cocarr](https://community.tiller.com/u/larry.cocarr)\ **Post date:** [July 13, 2020, 3:03pm UTC](https://community.tiller.com/t/split-transaction-workflow-shows-no-category-column-in-category-dropdown/4660/17 "2020-07-13T15:03:26Z")
Solving my problem had to be simple, and thanks to you, it was. How or when I did that I have no idea. But should it ever happen again, I’ll bet I can fix it on my own. Thanks Randy. Thank you very much. Larry Carr ---
**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\ **Post date:** [July 13, 2020, 3:05pm UTC](https://community.tiller.com/t/split-transaction-workflow-shows-no-category-column-in-category-dropdown/4660/18 "2020-07-13T15:05:12Z")
I wish I had noticed the issue earlier in your help request. Thanks for your patience. Randy ---
**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\ **Post date:** [July 15, 2020, 8:14pm UTC](https://community.tiller.com/t/split-transaction-workflow-shows-no-category-column-in-category-dropdown/4660/19 "2020-07-15T20:14:18Z")
🤦‍♀️ I should have thought of this.