Vlookup Contact List... Recognition after Save

Thomas Whiteley · 07/02/21

I'm using a helper column with Vlookup to populate a email address from a contact list sheet based on the name of the person in an adjacent column. The contact is populated properly when the sheet first opens but then it's like it is not recognized after a couple seconds of being open and thus is not brought into a filter based on the "Current User". What's even weirder is after the Save button is pressed, the contact is populated properly. See below formula and attachments.

Also attempting to assign them to a hierarchy but I don't think that is the issue.

=IF(ISBLANK([GTN Responsibility]@row), VLOOKUP(PARENT([GTN Responsibility]@row), {VLookUp Sheet Range 1}, 2, false), VLOOKUP(([GTN Responsibility]@row), {VLookUp Sheet Range 1}, 2, false))

GTN Responsibility = Person's Name

VLookUp Sheet Range = Contact List

2021.07.01 Smartsheet Contact Issue.mp4.zip

Bassam Khalil · 07/02/21

Hi @ThomasWh

Hope you are fine, try to use Index With Match instead of VLOOKUP

Thomas Whiteley · 07/02/21

https://community.smartsheet.com/discussion/comment/296864#Comment_296864

Unfortunately, the same thing is happening. When the sheet is opened or refreshed, the contact list is recognized for 4 seconds and then becomes unrecognized. Only after I press the Save button does it become recognized again.

New formula with Index/Match:

=IF(ISBLANK([GTN Responsibility]@row), INDEX({VLookUp Sheet Range 3}, MATCH(PARENT([GTN Responsibility]@row), {VLookUp Sheet Range 4}, 0), 0), INDEX({VLookUp Sheet Range 3}, MATCH([GTN Responsibility]@row, {VLookUp Sheet Range 4}, 0), 0))

Vlookup Contact List... Recognition after Save

Answers

Help Article Resources

Categories