String 1 = 'X' And String 2 = 'Y' Then String 3 = 'A' Else String 3

Question

This should be so straight forward, but not sure why my formula doesn't work.

Table:

Type RegionMGRASST MGRStoreILTomBillStoreGAJaneJaneShopILTimSueStoreGAJaneJaneShopILTimSueStore GAJaneJaneShopGAJenSam

OutPut Column [MGR]

Formula:

IF [Type]="Store"
AND [Region]="GA"
THEN "Mary"
Else [MGR]
ENDIF

Desired Result:

Type RegionMGRASST MGRStoreILTomBillStoreGAMaryJaneShopILTimSueStoreGAMaryJaneShopILTimSueStore GAMaryJaneShopGAJenSam

fmvizcaino · Accepted Answer

Hi @tcwildhart ,

Attached is a solution. I only copy pasted your formula into my workflow.

Maybe you have some additional spaces in your texts you need to remove in order to work.

Best,

Fernando V.

danilang · Accepted Answer

Hi @tcwildhart

I'm just going off the table that you posted, but it has these issues

1. The [Type] column has a trailing space in the column name

2. One of the "Store" values has a trailing space as well.

The first one will cause an error in your formula.  The second will not match since "Store " != "Store"

Dan