Need Help: Formula Sends Message for All Rows Instead of Score 20 | Clay

Need Help: Formula Sends Message for All Rows Instead of Score 20

Hello team! I'm writing a formula to send a message only if the score is 20, I used the AI formula generator and it seems to be correct when checking the preview, however when clicking on "RUN" it applies to ALL, could you help me? here is my table https://app.clay.com/workspaces/483567/tables/t_TqpzQnUiFVAd/views/gv_jyU9Dyq7vZ9p here is the formula I use {{Score Row in Clay}}?.score === 20 (from AI), thank you for your help!!

15 comments

Channeled
APP
·
·
It seems you're trying to create a conditional run but you've placed the formula in the wrong location. To make the enrichment run only for rows with a score of 20, you need to: 1. Go to the "Run Settings" of your enrichment column 2. Look for the "Only run if" box under Conditional Run 3. Enter your condition formula thereThe formula you're using looks correct, but it needs to be placed in the Run Settings to work as a conditional filter. When you click "RUN" without setting this up as a conditional run, it will naturally apply to all rows in your table. Sources: Conditional Formulas Guide: Ways to save Clay credits | Documentation | Clay University
Silvia E.
·
·
I did that, still not working
Silvia E.
·
·
proof
Channeled
APP
·
·
There seems to be an issue with your formula syntax. The correct way to reference a column in a conditional formula is by using "/" or directly using the column name in double curly braces without "?.". Here's how to fix it: 1. Your formula should be: ```
{{Score Row in Clay}} === 20 ```
To set this up correctly: 2. Go to the Run Settings 3. Find the "Only run if" box under Conditional Run 4. Either type the formula directly, or 5. Click "Use AI" and type in plain language "Only run if Score Row in Clay equals 20"You can verify if your condition works correctly by checking the sample outputs on the right side of the conditional formula editor. Sources: Conditional Formulas Conditional runs | Documentation | Clay University
Channeled
APP
·
·
Based on your formula, there are a few potential ways to fix this: 1. Try using the forward slash method to reference your column: /Score Row in Clay === 20 2. Or use the direct column name in double curly braces: {{Score Row in Clay}} === 20To verify if your condition works: 1. Go to Run Settings 2. Look for the "Only run if" box 3. Enter one of the formulas above 4. Check the sample outputs on the right side of the conditional formula editor to ensure it's working as expectedIf you're still having trouble, you can also: ** Click "Use AI" and type in plain language: "Only run if Score Row in Clay equals 20" ** Let the AI generate the correct formula for youThe formula structure should follow a simple if-else logic where if the condition is true, the enrichment runs; if false, it doesn't. Sources: Conditional runs | Documentation | Clay University Conditional Formulas
Silvia E.
·
·
Still not working 😞
Channeled
APP
·
·
Looks like you're still looking for help. 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!
Bo (.
·
·
Hey Silvia, The formula condition you set is only applied inside the Draft Email enrichment - it doesn't control whether the email is actually returned. This is something our product team is working on improving. For now, here's what you can do: 1. Use Views to filter out rows that don't meet the score === 20 condition. 2. Add a Run Condition on the next enrichment (e.g., the Sequencer) to prevent it from running unless the score is exactly 20. Let me know if you need help setting this up!
Silvia E.
·
·
Hello, thank you! Yes please, I do not get the 2nd step, could you help me?
Bo (.
·
·
Absolutely. I recorded this walkthrough video showing exactly how to set this up: https://cln.sh/9Dx00Tpk Let me know if you have any follow-up questions!
1
Silvia E.
·
·
Awesome! thank you 🙂
Silvia E.
·
·
Sorry! please ignore, this was resolved, thank you!!
Bo (.
·
·
Perfect, have a great night! :)
Channeled
APP
·
·
Hi Silvia E.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thank you so much for sharing your feedback Silvia E.!