How to build Search formula with specific conditions

[Learner09]

I am trying to add new column credit in my analysis. 

Below is the excel formula that I am trying to build in Alertyx.

=IF(ISNUMBER(SEARCH("*credit*",BE3)),"Yes","No")

Please see the attached example file and assist me 

[Jean-Balteryx · Accepted solution]

Hi @Learner09 ,

Here is an example workflow using the function Contains to check the presence of the value "credit" into your column.

Cheers,

Jean-Baptiste

[Learner09]

Thanks, Jean, you are superstar 🙂

[Jean-Balteryx]

Thank you @Learner09 , that's nice. I wish I was 🙂

Cheers,

Jean-Baptiste