# Table filter formula vs 'normal' formula discrepancy

**URL:** <https://connect.superhuman.com/t/table-filter-formula-vs-normal-formula-discrepancy/48610>\
**Category:** Ask the Community\
**Created:** [May 11, 2024, 11:23pm UTC](https://connect.superhuman.com/t/table-filter-formula-vs-normal-formula-discrepancy/48610 "2024-05-11T23:23:21Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Akash\_Agarwal](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/akash_agarwal/32/37437_2.png) [@Akash\_Agarwal](https://connect.superhuman.com/u/Akash_Agarwal)\
**Post date:** [May 11, 2024, 11:23pm UTC](https://connect.superhuman.com/t/table-filter-formula-vs-normal-formula-discrepancy/48610/1 "2024-05-11T23:23:21Z")

</div>

Hi all. I’m trying to use the gmail pack to sync 1000s of emails and then add a filter based on sender. I’ve been racking my head trying to implement a seemingly straightforward filter that excludes all the senders I specify.

So far, this formula works outside a table:

 ![image](https://global.discourse-cdn.com/coda1/original/3X/6/7/67eeafb9537e57347a349487941bf7fbcd165c3b.png)

However, the same doesn’t work as a filter within the table:

 ![image](https://global.discourse-cdn.com/coda1/original/3X/b/0/b01738317c51714770a00be70cc98379ad1bfc8b.png)

Is this a bug or am I doing something stupid?  
Cheers!

**Edit:** I’d like to add that I’ve tried a few different iterations in the table like:  
`Name.Contains(1, 2).Not()`  
`thisRow.Name.Contains(1, 2).Not()`

---

<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:** [May 12, 2024, 5:47am UTC](https://connect.superhuman.com/t/table-filter-formula-vs-normal-formula-discrepancy/48610/2 "2024-05-12T05:47:08Z")

</div>

For the filters inside a table you need to omit the Table.filter() part, imagine that’s already written 🙂

---

<div class="post-metadata">

**Author:** ![Akash\_Agarwal](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/akash_agarwal/32/37437_2.png) [@Akash\_Agarwal](https://connect.superhuman.com/u/Akash_Agarwal)\
**Post date:** [May 12, 2024, 6:41am UTC](https://connect.superhuman.com/t/table-filter-formula-vs-normal-formula-discrepancy/48610/3 "2024-05-12T06:41:50Z")

</div>

Thanks! I ended up having to use this:

```auto
thisRow.Name.Contains(List(1, 2)).Not()

```

Not sure why it didn’t work without the `List()` constructor.

---

<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:** [May 12, 2024, 7:19am UTC](https://connect.superhuman.com/t/table-filter-formula-vs-normal-formula-discrepancy/48610/4 "2024-05-12T07:19:24Z")

</div>

Awesome! Oh that’s odd, but you can try ContainsText instead perhaps

---

<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:** [August 10, 2024, 7:20am UTC](https://connect.superhuman.com/t/table-filter-formula-vs-normal-formula-discrepancy/48610/5 "2024-08-10T07:20:10Z")

</div>

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