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