Company name not working in formula

https://app.clay.com/workspaces/85244/tables/t_ZHtF9CWBgozA/views/gv_2NS5ECdfn6Kv

👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!

Hey there Leo thanks for reaching out, found what was causing this problem. The AI was confused because there was a missing a quotation mark that was throwing off the process. Added it in for you and the formula is now including the Company name. https://downloads.intercomcdn.com/i/o/1170289983/5d16c9552acba99cd9de4643/image.png?expires=1725563700&signature=512001d4303ec1e3f16089d4d6f2719f41d5e2996bd151f8258b934c04de1ce3&req=dSEgFst2lIhXWvMW1HO4zV05DpnTH%2Fi9%2BPr444qsadBUxco9Bg92dbfoj9p3%0AF9wc%0A

We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!