I have one formula field where I have used condition

IF(CONTAINS(Title, "Chief Architect"),"Architect")

So whenever I enter title Chief Architect the formula field appear as Architect

My issue is if someone enters Chief as chief Architect, cHief Architect or Chief architect. It wont populate I want to cover these all scenarios what should I do ?

1 Answer 1


You need to use the LOWER function as follows.

 IF(CONTAINS(LOWER(Title), "chief architect"),"Architect")

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .