I'm running a Clay column to find emails based on a specific condition. First, I used DeepSeek to determine whether the ICP is a good fit for my services. Then, I ran the same check using Llama. After that, I combined both results into another column using a function. Now, in the 'Find Email' column, I'm using the 'Only Run If' option to locate emails. However, even though some rows meet the 'Fit' criteria, they aren't running as expected. How do I fix these?
To fix your conditional run issue, check your formula syntax in the "Only Run If" section. Make sure it correctly references your combined "Fit" column and uses proper syntax (e.g., {Combined Fit Column} = "Good Fit"
).
If the formula looks correct but still isn't working, try simplifying it to isolate the problem. You might also need to check if your combined column contains unexpected values or formatting that doesn't match your condition.
Hey there Jaimin thanks for reaching out, sorry for the delay here, what is happening here is that for the rows that contains "Fit" followed by a newline character (an invisible line break), not just the word "fit". To make the condition true, you need to remove the extra newline or any spaces so that the field contains only the word "Fit" exactly.
Do you know how I can do that?
Apologies forgot to add in that we can do this with a formula column, the following loom shows how this would be done. https://www.loom.com/share/9155b9adae11492d888c764b160e1671?sid=1130c565-6516-43c7-acd4-1c0e24b7bbc2
That makes sense. Thanks so much!