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!
.png){kind=logo}
