Autopopulating contacts using vlookup

edited 12/09/19 in Formulas and Functions


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!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!