Bug Report: Conditional Formula Not Triggering Enrichment Process

Petar R. · 2025-11-24T04:12:54.329Z

hey guys I think there's a bug on my conditional formula. Please look at the screenshot. I have the condition for either of three columns to have more then 500 characters AND for one column not to equal to 'UNKNOWN'. Condition is correct, but the enrichment is not running. Even AI explanation does not sound logical. ERROR_RUN_CONDITIONS_NOT_MET is not UNKNOWN, so the column should run.

Bug Report: Conditional Formula Not Triggering Enrichment Process | Clay

Clay Support
APP
·
·
The issue isn't a bug - your conditional formula is working correctly. Based on the AI explanation in your screenshot, the condition is failing because both "Scraped Home Page" and "Scraped About Page" are empty or under 500 characters.
Your formula requires ANY of the three fields to have >500 characters AND "About Page Status" to not equal "unknown". While the status part passes (ERROR_RUN_CONDITIONS_NOT_MET ≠ unknown), the length requirement isn't met if only "Company and People Description (Final)" has enough content but the other two fields are empty.
To fix this, you can click the "explain" button for more details about why specific rows aren't meeting conditions. Consider testing your formula with edge cases like empty fields to ensure it handles missing data properly.
Clay Support
APP
·
·
Was that helpful?
Clay Support
APP
·
·
If you still need help with your conditional formula or want to clarify any part of the explanation, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific issues you’re encountering?
Petar R.
·
·
The conditional formula is not working correctly because column: linkedin description has more then 500 characters AND the columns About US Scrape Status does not equal to UNKOWN. Please connect me to a human agent.
Clay Support
APP
·
·
I understand your frustration, and I’ll connect you to a human agent who can assist you further.
Clay Support
APP
·
·
Our support team has got your message and we'll get back to you soon! We're currently outside of our standard office hours (9 AM to 9 PM EST, Monday through Friday), so it may take a little longer for us to respond.
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
image.png(93 kB)
Clay Support
APP
·
·
You can continue the conversation on WhatsApp instead.
Clay Support
APP
·
·
Messenger App
Petar R.
·
·
https://app.clay.com/workspaces/738339/workbooks/wb_0t617x2pkV3ZwA5p4ek/tables/t_0t61fc3s5m8XAamKFjM/views/gv_0t61fc3nCvxhggFC375
Sayli G.
·
·
Hello Petar! Thanks for reaching out! Took a look and can see you changed the run condition. Can you tell me if the issue got resolved?
Petar R.
·
·
Sayli G. nope, I changed the condition so that I can solve the issue. It's a bug probably. Or I was not thinking straight because it was 5am my time and I was wrapping up my day lol. Can you check this somehow?
Petar R.
·
·
Hey Sayli G. seems like I have another problem now in another table. I have two sources from which I'm mapping the final website url to one column. As you can see on the screenshot it's empty but the formula looks good. What's wrong here? Link to table: https://app.clay.com/workspaces/476674/workbooks/wb_0t4wuvhENFCK8BEFawc/tables/t_0t55m6q2G9XUfbKMq8X/views/gv_0t55m6sd5nU6trqgZKr Can you get back to soon on this?
Loading attachments
Sayli G.
·
·
Is the new one working? It could be a buggy column but will be difficult for me to troubleshoot since it has hence been changed.
Sayli G.
·
·
Taking a look at #2
Sayli G.
·
·
Hi! Thanks for reaching out. I looked into the issue with merging your company domain columns.
Good news, your logic is working correctly! I checked where your first source ends (row 152) and the second source begins, and the merging is functioning properly across both sources.
The issue: I noticed some blank sections further down in your table. When I investigated, I found that the data exists but under different field names. For example, when I search for "domain final" in your source columns, nothing shows up - but there's "domain", "domain limited", "website", and several other fields that could contain this information.
My recommendation: Instead of using a formula column, use the Merge Columns feature (it's free, no credits spent). Here's why:
You can add ALL possible field names that might contain domain data
You can rearrange the priority order if multiple fields have data
You can keep adding inputs as needed
It's more reliable for handling data from different sources
How to do it:
1.
Pull out all potential domain columns as standalone columns first
2.
Use the Merge Columns option to combine them
3.
You can hide the individual columns afterward if you want
This will give you an exhaustive merge that catches all domain data regardless of field name.
Let me know if I'm missing something or if you need help setting this up!

18 comments