I'm trying to create a custom column that calculates different values based on specific components. I'm looking for a formula that will look at the component field and determine whether the component is present.
I think Match should do it but I can't work out how to use it with a field.
Help will be greatly appriciated.
Zigi