Hi, I have a problem with having a formula identify job titles. In my table, I have a column with job titles. I set up a formula where if it identifies certain job titles such as "CEO, COO, CFO, Founder", it will then return either True or False. The issue that I am facing now is when there are names such as "Cook", which ends up being noted as True since it contains the words "COO". On the other-hand, certain titles such as "COO and Co-Founder" are being identified as False. Would love to get some insights into what would be the best approach to this issue! Thank you!
💤 You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!
Hey Sam, I would use OpenAI api. Write a prompt with steps will solve you issue. add a openai account to clay and use 3.5 or 4 mini super cheap
Ofcourse try this Act like a Data Expert, you are expert in finding CXO level people from its Job Title Using the input /Jobtitle analysis title and if the title are as following:
CEO,
COO,
CFO,
Founder
Return the output as "True" , and "False" if it didn't match the above job title. The output should be only True & False no explanation needed.
Nice! I'll be sure to try it
Thank you!
Hey there Samuel thanks for reaching out and appreciate you jumping in Nishil! Let us know if you have any other issues and if you do could you post a link to the table where it is occurring so that we can take a look.
