I cant write my own formula it is showing errors
That “Invalid formula” usually means the formula editor can’t parse something in the expression. A couple quick things to try:
Can you paste the exact formula text you’re trying to save (copy/paste from the editor)?
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;
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]
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?
