How to use the field Test_Repository_Path in formula column in Jira on Prem

[Galit Levitats]

I am trying to use the field Test_Repository_Path in formula Column in structure 

COUNT { IF CONTAINS(Test_Repository_Path, "לקוחות") : 1 }

The formula seems to be correct but it doesn't work - the result is 0

the Test_Repository_Path contains th value  "ועדות/ועדות לקוחות, ילד נכה"  

What is the corrects syntax?

thanks

[Stepan Kholodov _Tempo_]

Hello @Galit Levitats 

The CONTAINS() function doesn't perform text matching. If you want to check a text value for certain words/symbols, you need to use a different method. For example: IF SEARCH("לקוחות",summary) : 1

I hope this helps. If you have more questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)

[Galit Levitats]

Thanks!! it worked!