We have a column that contain multiple information in the same string
Column: Service Activities
Example value: IT operations, IT development, User support, Special agreement
I would like to count the application as 1 in my new field "Appl IT Dev" if it has 'IT development' as part of the string.
I have tried using following formula:
=if(Service Activities = Search("IT dev",{Service Activities}),1,0)
It is not working as expected. What do I do wrong?
We have only 3 applications where the string text only is IT development. So the formula without the search function works fine:
=if(Service Activities = "IT development",1,0)
But I need the search function to work :-)
#CostingStandard(CT-Foundation)