I have a column that was a name of a product, which is customer-facing, and I have another column that I use for myself. I would like to create a formula where
if (Column B contains the word Blue)
output BLUE to column B
If (Column B contains the word Whale)
output WHALE in column B
If neither is true output ERROR
I’ve tried so many options, nested ifs, and substitutes … I only have 5 products, so I also tried using a switch statement … but it’s not working … does it only work with integers?