# Table Filter Not Working

**URL:** <https://connect.superhuman.com/t/table-filter-not-working/39054>\
**Category:** Ask the Community\
**Created:** [April 11, 2023, 3:44am UTC](https://connect.superhuman.com/t/table-filter-not-working/39054 "2023-04-11T03:44:40Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alyssa\_Gono](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/alyssa_gono/32/28296_2.png) [@Alyssa\_Gono](https://connect.superhuman.com/u/Alyssa_Gono)\
**Post date:** [April 11, 2023, 3:44am UTC](https://connect.superhuman.com/t/table-filter-not-working/39054/1 "2023-04-11T03:44:40Z")

</div>

I created a selector filter for the table ‘Auto-CodeBook’ labeled ‘Review Status’ and named ‘Auto-Juris View Review Status Selector’

 ![image](https://global.discourse-cdn.com/coda1/original/3X/2/a/2a13177caa7c8ea27bbfbec59bb75aa7aa588edd.png)

The selector filter value must be equal to the column ‘Reviewed Entry’ value of the table.

 ![image](https://global.discourse-cdn.com/coda1/original/3X/c/8/c82a8c196afe84cc153a426eb41fc8658cb4ef34.png)

thisRow.[Reviewed Entry]==[Auto-Juris View Review Status Selector]

The formula above is what I used for filtering rows., but it doesnt work.

 ![image](https://global.discourse-cdn.com/coda1/original/3X/3/2/32a493e2736e9b08ec4c04eb7a4474d6c833da7f.png)

![image](https://global.discourse-cdn.com/coda1/original/3X/3/1/3112416f8aff029e424528040135c105915d8b66.png)

It seems like ‘thisRow.[Reviewed Entry]’ is returning a single value and ‘[Auto-Juris View Review Status Selector]’ is returning a list of options that is why it does filter correctly. How to fix it ?  
I have to get the current value of the select dopdown.

---

<div class="post-metadata">

**Author:** ![Rickard\_Abraham](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/rickard_abraham/32/35007_2.png) [@Rickard\_Abraham](https://connect.superhuman.com/u/Rickard_Abraham)\
**Post date:** [April 13, 2023, 4:51am UTC](https://connect.superhuman.com/t/table-filter-not-working/39054/2 "2023-04-13T04:51:56Z")

</div>

I didn’t know you could use two equal signs in coda, I always use one. Maybe try that?

---

<div class="post-metadata">

**Author:** ![Alyssa\_Gono](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/alyssa_gono/32/28296_2.png) [@Alyssa\_Gono](https://connect.superhuman.com/u/Alyssa_Gono)\
**Post date:** [April 13, 2023, 5:05am UTC](https://connect.superhuman.com/t/table-filter-not-working/39054/3 "2023-04-13T05:05:19Z")

</div>

I tried that as well, but it did not work. The problem is Auto-Juris View Review Status Selector returns a list of options, not the current value of the dropdown.

---

<div class="post-metadata">

**Author:** ![Pch](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pch/32/17688_2.png) [@Pch](https://connect.superhuman.com/u/Pch)\
**Post date:** [April 13, 2023, 9:23am UTC](https://connect.superhuman.com/t/table-filter-not-working/39054/4 "2023-04-13T09:23:42Z")

</div>

Hi @Alyssa_Gono 😊 !

Have you tried to use [Matches()](https://coda.io/formulas#Matches) ? 😊

Something like :

```auto
thisRow.[Reviewed Entry].Matches([Auto-Juris View Review Status Selector])

```

`Matches()` exists specifically to easily compare a value from a canvas control to something else 😊 …

I’m not sure how the text values in your canvas select control will be interpreted by Coda though as you’re comparing a boolean (`thisRow.[Reviewed Entry]`) to a text value ( `[Auto-Juris View Review Status Selector]`) apparently …

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [July 12, 2023, 9:24am UTC](https://connect.superhuman.com/t/table-filter-not-working/39054/5 "2023-07-12T09:24:26Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.