Clay Icon
Join the Community
02 Support

Troubleshooting Job Title Identification Formula in Excel

Avatar of Samuel C.Samuel C.
·
·

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

  • Avatar of Channeled
    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!

  • Avatar of Nishil P.
    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

  • Avatar of Samuel C.
    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

  • Avatar of Nishil P.
    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. 1.

      CEO,

    2. 2.

      COO,

    3. 3.

      CFO,

    4. 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.

  • Avatar of Samuel C.
    Samuel C.
    ·
    ·

    Nice! I'll be sure to try it

  • Avatar of Samuel C.
    Samuel C.
    ·
    ·

    Thank you!

  • Avatar of LuisArturo
    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.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Samuel C.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: