# 'Transactions' tab 'Group' category Error issue

**URL:** <https://community.tiller.com/t/transactions-tab-group-category-error-issue/22913>\
**Category:** Google Sheets\
**Tags:** troubleshooting\
**Created:** [January 12, 2024, 8:17pm UTC](https://community.tiller.com/t/transactions-tab-group-category-error-issue/22913 "2024-01-12T20:17:16Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ryan11](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/ryan11/32/5865_2.png) [@ryan11](https://community.tiller.com/u/ryan11)\
**Post date:** [January 12, 2024, 8:17pm UTC](https://community.tiller.com/t/transactions-tab-group-category-error-issue/22913/1 "2024-01-12T20:17:16Z")

</div>

I’m making a new spreadsheet to replace my 2023 version, it became too riddled with issues so I’m starting fresh. On the ‘transactions’ tab I have added a ‘group’ column as per the instructions listed here:

> **[Add a Group column to the Transactions Sheet | Tiller Help Center](https://help.tillerhq.com/en/articles/3137561-add-a-group-column-to-the-transactions-sheet)**
>
> Learn how you can display the category group alongside your other data in the Transactions sheet.

The ‘group’ column is able to properly reference the ‘category’ column and the text string is fine. However, I still get the following error message:  
-Red triangle in the top right corner of the cell with the note…  
- **Invalid:** Input must fall within specified range

---

<div class="post-metadata">

**Author:** ![yossiea](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/yossiea/32/4643_2.png) [@yossiea](https://community.tiller.com/u/yossiea)\
**Post date:** [January 12, 2024, 8:27pm UTC](https://community.tiller.com/t/transactions-tab-group-category-error-issue/22913/2 "2024-01-12T20:27:06Z")

</div>

Try this formula instead, and just edit the columns where applicable.

```auto
=ARRAYFORMULA(IFERROR(VLOOKUP(D:D,Categories!A:B,2,FALSE),IFERROR(1/0)))

```

---

<div class="post-metadata">

**Author:** ![ryan11](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/ryan11/32/5865_2.png) [@ryan11](https://community.tiller.com/u/ryan11)\
**Post date:** [January 12, 2024, 8:38pm UTC](https://community.tiller.com/t/transactions-tab-group-category-error-issue/22913/3 "2024-01-12T20:38:49Z")

</div>

I fixed it using ‘Data validation’ from this:

> [@Category error: Invalid: Input must fall within specified range](https://community.tiller.com/t/category-error-invalid-input-must-fall-within-specified-range/10271):
>
> On my transactions page, in Google Sheets, in the category column, most are marked red with the text Invalid: Input must fall within specified range What does this mean? How do I fix it? Thank you!

---

<div class="post-metadata">

**Author:** ![Mark.S](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/mark.s/32/14650_2.png) [@Mark.S](https://community.tiller.com/u/Mark.S)\
**Post date:** [January 12, 2024, 8:40pm UTC](https://community.tiller.com/t/transactions-tab-group-category-error-issue/22913/4 "2024-01-12T20:40:10Z")

</div>

My guess is that you inserted a Transactions sheet column when the Category column was selected, which would copy the Category column data validation rules.

If so, delete the column you added and insert a column elsewhere.