Automate Cell Linking??

OORF

I have an smartsheet "employee table" that contains employee names and employee IDs. I also have a smartsheet "activity" that logs employee activity via a smartsheet form. The goal is to pull the employee ID from the the "employee table" smartsheet and copy / input it into the Employee ID column of the "activity" smartsheet.

I have done this for one row manually via cell linking, but I was wondering if there was a way to automate the cell linking or a different automation to input the employee ID from the "employee table" when a new submission is made from an employee in "activity". (Join the two tables by Employee Name so that when a new submission is made, the employee ID will auto populate).

Paul Newcome

You would use an INDEX/MATCH with cross sheet references.

=INDEX({Reference Sheet Employee ID Column}, MATCH([Employee Name]@row, {Reference Sheet Employee Name Column}, 0))

Paul Newcome

You would use an INDEX/MATCH with cross sheet references.

=INDEX({Reference Sheet Employee ID Column}, MATCH([Employee Name]@row, {Reference Sheet Employee Name Column}, 0))

OORF

@Paul Newcome Thank you!

Paul Newcome

Happy to help. 👍️