Hello! I am trying to create a custom column where I need to use the replace function to change several items at once. Just for sake of simplicity, let's say I have a category column which can be "A", "B", "C", "X", "Y" and "Z".
I wanted to create a custom column where every instance of "X" is replaced by "A", "Y" is replaced by "B" and "Z" is replaced by "C". How can I write this formula for it to be valid? (I tried all different ways to write it as I could think of and I got a syntax error every single time).
Thank you very much!