Using If/Then with Replace in Formula Tool

Question

I have a workflow where I need to change the current name in a field to another name if the condition is met. I have the formula set up, but when I run my workflow, it does not replace the old name with the new. Any ideas on what I am doing wrong? This is not the real scenario, just an example.

alexnajm · Accepted Answer

This is correctly constructed syntax-wise although odd because it won't do anything - this tells me if the value in column a equals “dog”, then replace any instance of “animal” with “pet”, otherwise leave it alone. It is not going to do anything since you’re asking it to look for a “dog”, but you want to replace “animal”.

can you provide proof of your formula not working? Maybe this is what you want, to replace "Dog" with "Pet"?

IF [ColumnA]="Dog" THEN Replace([ColumnA], "Dog", "Pet") ELSE [ColumnA] ENDIF

caltang · Accepted Answer

Maybe you don’t have have Dog as a stand alone. You need CONTAINS([ColumnA],”Dog”) then continue your IF statement rather than [ColumnA] = “Dog”.

Also, case sensitive! You can either use UpperCase(), LowerCase(), or TitleCase() to standardize.