Help

Creating a formula from another column

Topic Labels: Formulas
661 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Lost-Merovingia
7 - App Architect
7 - App Architect

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?

0 Replies 0