Hello ,
I have this requirement to write a formula :
4 columns A , B , C and D are a part of workflow .
A = Sales Area
B = Jurisdiction
C = email id of Sales Person
D = copy of column c
A | B | C | D |
SalesArea1 | SalesArea1 | aac@gmail.com | aac@gmail.com |
SalesArea2 | SalesArea5 | bbx@gmail.com | bbx@gmail.com |
SalesArea3 | SalesArea3 | ccx@gmail.com | ccx@gmail.com |
SalesArea5 | SalesArea5 | xsx@gmail.com | xsx@gmail.com |
My requirement is if A !=B then column D must be updated with the corresponding email id available for B .
A | B | C | D |
SalesArea1 | SalesArea1 | aac@gmail.com | aac@gmail.com |
SalesArea2 | SalesArea5 | bbx@gmail.com | xsx@gmail.com |
SalesArea3 | SalesArea3 | ccx@gmail.com | ccx@gmail.com |
SalesArea5 | SalesArea5 | xsx@gmail.com | xsx@gmail.com |
Thanks
@praneshsapmm
I believe that is what I and @PKoya ar trying to do.
or you can provide a larger dataset to validate?