Replacing a field from separate column

Question

I have a column that contains two locations from the extract, there is another column that indicates if they are in both locations.

I want to combine this into a single column.

I wrote a formula, also tried this in a multi-row formula with the same results, that in essence is:

IF [InBOTH] = 'Yes'
THEN [Data Source] = 'In Both'
ELSE [Data Source] 
ENDIF

Which ends up putting zeros in the Data Source column instead of the string I would like there.

I've tried several iterations of the same logic with the same results.

????

Jonathan-Sherman · Accepted Answer

Hi @GoldenDesign04,

Your syntax is not quite right, you were nearly there!

IF [InBOTH] = 'Yes'
THEN 'In Both'
ELSE [Data Source]
ENDIF

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan