Filter Lookup Column to Exclude '✅ 1 Record Found' Rows

To filter out rows with '✅ 1 record found' in a lookup column in Clay, you can use the Filter feature. Here's how: 1. Click the "Filter" button above your table. 2. Select the lookup column you want to filter. 3. Choose "does not contain" as the filter operator. 4. Enter "✅ 1 record found" (without quotes) in the value field. This will hide all rows where the lookup column contains that specific text, effectively removing them from view. If you need further assistance, you can request human help by clicking on "Talk to a person" in the chat.

Source: Hide, Re-order, Sort, Filter, Merge Columns

I apologize for the confusion earlier. Since the specific filter option isn't available, we can use a workaround to achieve the same result. Here's what you can do: 1. Click "Filter" above your table. 2. Select the lookup column you want to filter. 3. Choose "does not contain" as the filter operator. 4. Enter "✅" (without quotes) in the value field. This will hide all rows where the lookup column contains the checkmark emoji, effectively removing the "✅ 1 record found" entries from view. If you need to further refine your filter, you can add additional conditions using the same method. If you need more assistance or this doesn't solve your issue, please request human help by clicking on "Talk to a person" in the chat.

Source: Hide, Re-order, Sort, Filter, Merge Columns

Hey there Joel thanks for reaching out, do you mind sending the link (url) to the table so we can take a look?

Hey there Joel made a loom showing how to do this: https: //www.loom.com/share/84a2c4effd444eacb7d479390e95d2a2?sid=a03aba2c-1516-49a0-874e-2e967c991464