This should be so straight forward, but not sure why my formula doesn't work.
Table:
Type | Region | MGR | ASST MGR |
Store | IL | Tom | Bill |
Store | GA | Jane | Jane |
Shop | IL | Tim | Sue |
Store | GA | Jane | Jane |
Shop | IL | Tim | Sue |
Store | GA | Jane | Jane |
Shop | GA | Jen | Sam |
OutPut Column [MGR]
Formula:
IF [Type]="Store"
AND [Region]="GA"
THEN "Mary"
Else [MGR]
ENDIF
Desired Result:
Type | Region | MGR | ASST MGR |
Store | IL | Tom | Bill |
Store | GA | Mary | Jane |
Shop | IL | Tim | Sue |
Store | GA | Mary | Jane |
Shop | IL | Tim | Sue |
Store | GA | Mary | Jane |
Shop | GA | Jen | Sam |
Solved! Go to Solution.
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.
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
Thanks to both of you... The good news is that I had it all right, the bad (and good) news is that I need to scrub my input before using it to calculate. Thanks!