Autopopulating contacts using vlookup

Hi,

I have a sheet with several formulas, including a =vlookup on a text cell and =Join (). All these formulae autopopulate when a new row is added manually of via a form submission.

However, I also have a contact column which, while successfully pulling the contact information into the cell using a =vlookup function, is not autopopulating the =vlookup formula when subsequent rows are added.

There are at least two rows of formulas above....

Any suggestions as to why this might not be working would be much appreciated!

Thanks

Find more posts tagged with

Formulas

Project Management

Comments

Andrée Starå

Hi,

That's strange!

If you haven’t already, I would recommend that you reach out to the Smartsheet Support Team. Smartsheet Support Team

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Andrée Starå

Are the formulas identical?

IBRIEOG

Hi,

The formulas that are autopopulating on new row entries are-

=[column name]1+1

=vlookup($[Column name]$1, reference table,3,false) returning a text value in a text column

=JOIN([Column name]:[Column Name])

The formula/s which are not autopopulating on the same new row entries are-

=vlookup($[Column name]$1, reference table,8,false) returning a contact value in a contact column

So the difference seems to be the column type being a contact list?

Paul Newcome

It could be a bug spawning from the fact that formulas in contact columns are still new.

I second Andree's suggestion of getting in touch with Support.

IBRIEOG

Thanks - I have lodged a support ticket and will post any solutions found

Andrée Starå

Look at some of the last messages in this post for more information. https://community.smartsheet.com/announcement/announcing-formula-support-contact-columns

Let us know how it goes!

Sign in to join the conversation!

Quick Links

Trending discussions

How to split contents from a cell from a smartsheet into another smartsheet
I need to extract and split the contents of a cell in a Smartsheet into three separate columns to a new smartsheet. The cell entries are originally submitted through a form.
Information in a form populates specific cell.
Hello, Just investigating an idea. I'm building a staff register sheet. I'm curious to know if its possible to populate specific cells by the answers given in a form? So if, in a form, a staff member gives their name, the date and that they will be on leave, sick, training ect. Once the form is submitted, it will populate…
A multiple SUMIF function
My current formula is below. I would like to update this so that I only get a total of those that have been Quoted and have a timeframe data of 2025. How do I add this extra filter into the formula? =SUMIF(Status:Status, "Quoted", [Est. GP]:[Est. GP])