Clay Icon

Formula in Linkedin Connection Follow-up Column Error: Field Name Instead of Value

ยท
ยท

Why is this formula in the "Linkedin Connection Follow-up" column spitting out the field name, rather than the value in the field? Here is the "Use AI"-generated formula: {{Lookup Lead Status in Campaign}}?.number_of_sent_emails ? `Thanks for connecting, ${{{Normalized First Name}}?.result}. Mind if I send you a <1 min video on AutoWiki?` : `Thanks for connecting, ${{{Normalized First Name}}?.result}. I figured your team at ${{{Normalized Company Name}}?.result} spends a ton of time writing documentation and keeping it up to date. I built a tool that converts repos to Wiki style docs with citations that are always up to date. Want to test it out?` The correct output should be: Thanks for connecting, FIRST NAME. I figured your team at COMPANY NAME spends a ton of time writing documentation and keeping it up to date. I built a tool that converts repos to Wiki style docs with citations that are always up to date. Want to test it out? The current, incorrect output is: Thanks for connecting, ${{{f_IcMLl56TNmLp}}?.result}. I figured your team at ${{{f_MyvevT5qpVWg}}?.result} spends a ton of time writing documentation and keeping it up to date. I built a tool that converts repos to Wiki style docs with citations that are always up to date. Want to test it out?