Match Cell Content in New (Form Provided) Rows with Content in Previous Rows

Justin Seeling
edited 03/30/21 in Formulas and Functions


I am looking to use a formula to bring an entry from an existing cell into a new row when another column in that row matches.

I will be deploying a Smartsheet webform, and when the last name of a respondent matches in a new response, I want that new row to automatically contain the Dropbox folder for recorded in the Indexed cells.

Can you help me with this?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!