I cant write my own formula it is showing errors

I cant write my own formula it is showing errors | Clay

4 comments

· Sorted by Oldest

Clay Support
APP
·
·
That “Invalid formula” usually means the formula editor can’t parse something in the expression. A couple quick things to try:
Make sure you’re referencing columns the Clay way (e.g. {{Employee Count}}) - Clay passes that value into your expression automatically. [1]
If you want conditionals, try using an IF … ELSE style structure (Clay supports conditional statements). [2]
If it’s annoying to hand-write, try the AI formula generator to create the formula from a plain-English description, then tweak it. [3] [4]
Can you paste the exact formula text you’re trying to save (copy/paste from the editor)?
Saravanan R.
·
·
let score = 0; if ({{Hiring for GTM Roles?}} == "Yes") score += 30; if ({{Category}} && {{Category}}.toLowerCase().includes("ai")) score += 20; if ({{Employee Count}} && {{Employee Count}} < 200) score += 20; if ({{Relevant Careers Page}} == "Yes") score += 10; if ({{Executive Contacts no title}} && {{Executive Contacts no title}}.toLowerCase().includes("founder")) score += 20; return score;
Clay Support
APP
·
·
Your formula is erroring because Clay formulas expect a single JavaScript expression, and Clay passes column values in when you reference them like {{Column Name}} (not #{{...}}). [1] [2]
Try rewriting without let/if/return, as one expression, e.g.:
({{Hiring for GTM Roles?}} === "Yes" ? 30 : 0) + ({{Category}} && {{Category}}.toLowerCase().includes("ai") ? 20 : 0) + (Number({{Employee Count}}) < 200 ? 20 : 0) + ({{Relevant Careers Page}} === "Yes" ? 10 : 0) + ({{Executive Contacts no title}} && {{Executive Contacts no title}}.toLowerCase().includes("founder") ? 20 : 0)
If you want, you can also use the AI Formula Generator: add a Formula column, describe the scoring, then “Generate Formula”. [3]
Clay Support
APP
·
·
If you still need help with writing your formula or understanding the error, I’m here to assist. Would you like to provide more details about what you’re trying to achieve with the formula?

Clay Support
APP
·
·
That “Invalid formula” usually means the formula editor can’t parse something in the expression. A couple quick things to try:
Make sure you’re referencing columns the Clay way (e.g. {{Employee Count}}) - Clay passes that value into your expression automatically. [1]
If you want conditionals, try using an IF … ELSE style structure (Clay supports conditional statements). [2]
If it’s annoying to hand-write, try the AI formula generator to create the formula from a plain-English description, then tweak it. [3] [4]
Can you paste the exact formula text you’re trying to save (copy/paste from the editor)?
Saravanan R.
·
·
let score = 0; if ({{Hiring for GTM Roles?}} == "Yes") score += 30; if ({{Category}} && {{Category}}.toLowerCase().includes("ai")) score += 20; if ({{Employee Count}} && {{Employee Count}} < 200) score += 20; if ({{Relevant Careers Page}} == "Yes") score += 10; if ({{Executive Contacts no title}} && {{Executive Contacts no title}}.toLowerCase().includes("founder")) score += 20; return score;
Clay Support
APP
·
·
Your formula is erroring because Clay formulas expect a single JavaScript expression, and Clay passes column values in when you reference them like {{Column Name}} (not #{{...}}). [1] [2]
Try rewriting without let/if/return, as one expression, e.g.:
({{Hiring for GTM Roles?}} === "Yes" ? 30 : 0) + ({{Category}} && {{Category}}.toLowerCase().includes("ai") ? 20 : 0) + (Number({{Employee Count}}) < 200 ? 20 : 0) + ({{Relevant Careers Page}} === "Yes" ? 10 : 0) + ({{Executive Contacts no title}} && {{Executive Contacts no title}}.toLowerCase().includes("founder") ? 20 : 0)
If you want, you can also use the AI Formula Generator: add a Formula column, describe the scoring, then “Generate Formula”. [3]
Clay Support
APP
·
·
If you still need help with writing your formula or understanding the error, I’m here to assist. Would you like to provide more details about what you’re trying to achieve with the formula?