Troubleshooting Job Title Identification Formula in Excel

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!

8 comments

Channeled
APP
·
·
💤 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!
Nishil P.
·
·
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
Samuel C.
·
·
Nishil P., Thanks for this! Any idea what the prompts steps would be? Been trying on my end but it doesn't seem to catch the titles entirely
Nishil P.
·
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:
1.
CEO,
2.
COO,
3.
CFO,
4.
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.
Samuel C.
·
·
Nice! I'll be sure to try it
Samuel C.
·
·
Thank you!
LuisArturo
·
·
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.
Channeled
APP
·
·
Hi Samuel C.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

Troubleshooting Job Title Identification Formula in Excel | Clay