Referencing a Contact with VLOOKUP

I have an employee list that has a column for "supervisor", which is a "Contact" type column, allowing the selection of a supervisor from a pre-defined list.

I have another sheet, a time sheet, which needs to reference that supervisor column with vlookup so that approvals can be sent to that person for hours logged. It must be a "Contact" type column to allow the column to be used in the approval request rules ("Send an approval request o" -> "Contact in column"). However, it seems like I can't use vlookup in a Contact type column - it returns "#INCORRECT ARGUMENT SET".

Is what I'm trying to do not possible?

Find more posts tagged with

Cell linking

Account and User Management

Comments

Mike Wilday

Hello, no. At this current time it is not possible to place formulas in the contact column. For whatever reason, you can't reference other cells in contact columns and are required to manually enter your contacts there. It would be a great feature and one I've requested multiple times. Please add your vote by submitting a product enhancement request.

gdi2k

Thanks, I went ahead and filled out the product enhancement form.

Tamara Gordon Berlik

Do you have a workaround for this? I have multiple sheets I am doing the same on and am wondering how you are dealing with this until the Contacts columns can use a formula?

Mike Wilday

At this point, I don't have a workaround. We use a Handoff-To Column that we populate with the assignee of the task that follows the current one but it has to be manually populated. Kind of a bummer.

Parkyreiner

If this works it will be very useful.

Thx

Andrée Starå

Hi everyone,

Formulas in contact columns. It's released now!

https://community.smartsheet.com/announcement/announcing-formula-support-contact-columns

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Sign in to join the conversation!

Quick Links

Trending discussions

Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
Why are my answers not showing up when a document is generated?
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…