Automate Cell Linking??
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).
Best Answer
-
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))
Answers
-
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 Thank you!
-
