|
If you don't mind, let's go a step back: You have column A which admits three values. Is that a predefined column or an existing column?
If it is a predefined one, you would have to go with chaley solution:
1.- Create custom column B, which will have only the new values
2.- Create custom column C (composite created based on other columns), and the function will be the function chaley has written before.
So, now you will have to introduce values in A or B depending of the value and C will show always the proper value.
If A is a custom column, the easiest way to do it is to modify column A to add new values.
I guess it will be predefined, but only to be sure.
|