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

Justin Seeling

Hello

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?

Thanks,

Justin

Paul Newcome

You would need to insert another column and use a formula such as this:

=INDEX(COLLECT([Dropbox Folder]:[Dropbox Folder], [Last Name]:[Last Name], @cell = [Last Name]@row, [First Name]:[First Name], @cell = [First Name]@row), 1)

Paul Newcome

You would need to insert another column and use a formula such as this:

=INDEX(COLLECT([Dropbox Folder]:[Dropbox Folder], [Last Name]:[Last Name], @cell = [Last Name]@row, [First Name]:[First Name], @cell = [First Name]@row), 1)

Justin Seeling

Thanks, Paul.

If I wanted to just rely on the match of the Last Name, not necessitating a first name match from the Index, could you let me know what that formula would look like?

Paul Newcome

You would have to remove the First Name range/criteria set.

=INDEX(COLLECT([Dropbox Folder]:[Dropbox Folder], [Last Name]:[Last Name], @cell = [Last Name]@row), 1)