# Bug: switching from Lookup column type to List column type doesn't remove references to the rows from the lookup source table

**URL:** <https://connect.superhuman.com/t/bug-switching-from-lookup-column-type-to-list-column-type-doesnt-remove-references-to-the-rows-from-the-lookup-source-table/17889>\
**Category:** Bugs\
**Created:** [August 19, 2020, 1:40pm UTC](https://connect.superhuman.com/t/bug-switching-from-lookup-column-type-to-list-column-type-doesnt-remove-references-to-the-rows-from-the-lookup-source-table/17889 "2020-08-19T13:40:27Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![Andrei\_Kharlanov](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/andrei_kharlanov/32/16627_2.png) [@Andrei\_Kharlanov](https://connect.superhuman.com/u/Andrei_Kharlanov)\
**Post date:** [August 20, 2020, 9:44am UTC](https://connect.superhuman.com/t/bug-switching-from-lookup-column-type-to-list-column-type-doesnt-remove-references-to-the-rows-from-the-lookup-source-table/17889/3 "2020-08-20T09:44:36Z")

</div>

@Ben_Lee, it’s not a huge deal, I just wanted to share so Coda team is aware of this behavior.

I understand that I can delete values from the column, but you can imagine if the table is big — it’s a big task to delete and select correct values for all the rows.

By the way, to give you context why I tried to change Lookup type column to List type column: because when grouping a table by text values from the list you can choose which groups to show even if they don’t have any rows currently (with the pin button in the grouping settings) and filter out groups that you don’t want to show (with the table filter).

The fact that you can’t set pins (“always show this group”) and filter out unwanted groups when you are grouping by the lookup column is killing me and makes project management system that I’m building in Coda much more difficult to create.

It’s double pain when you group by two lookup columns (Initiatives and Projects in Tasks table in my system).

Are you thinking about **extending grouping settings to lookup groups** in some near future?

Here is a post in Suggestion Box about same problem from another user:

> [@\[Feature Request\] Enable Group Pinning options for Look Up Table column](https://connect.superhuman.com/t/feature-request-enable-group-pinning-options-for-look-up-table-column/9571):
>
> When a column is detected with a number of Coda objects from a foreign table, pinning is disabled for groupings using that target column. Because of this, I either have an excessive amount of columns when grouping on this column, or cannot see columns for which no cards exist - preventing me from using a proper Kanban workflow. What am I trying to achieve I want to have a master database that has a column “Status” to indicate a task status, and multiple different views into it in card view th…

---

_[View the full topic](https://connect.superhuman.com/t/bug-switching-from-lookup-column-type-to-list-column-type-doesnt-remove-references-to-the-rows-from-the-lookup-source-table/17889)._
