Contact Cells that match
Pulling my hair out!
I have two fields, lets call them Manager 1 and Manager 2. Both are vlookups from a central approval names sheet. Works fine and no problems.
I have a situation, because both fields are used in an approval flow, where I want the approval to only go to Manager 2 if that person is the same as Manager 1 to make it more efficient.
I hoped it would be a simple extra field to check if the two values match but I just cant get it to work.
I have the email address saved in my personal contacts to show the name in the correct format I want but in Manager 1 field, it shows as full email address and Manager 2 as the contact name format for that email address. Is this why they will not match?
Anyone have an idea?
Help Article Resources
Check out the Formula Handbook template!