Autopopulating contacts using vlookup

IBRIEOG

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

 

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!