How do I make formulas automatically carry down to the next line when a new form is submitted?

TJones Hoshizaki
edited 07/23/20 in Smartsheet Basics

I have a sheet that is being fed by a form. I am using a vlookup to add contact data from another sheet dependent on the email of the person who submitted the form.

I want those vlookups to be added automatically to each line as new forms are submitted.

How do I do this?

Tags:

Answers