Searched all over for Clear Instructions on Referencing a Column of Values in One Sheet in Another

obprojectservices

I have one sheet (list of Employee). Each employee has an Employee ID (auto column).

I have another sheet (Hours per Employee). Each employee submits their hours worked via a form.

I want the Employee IDs that exist in the list of Employees to automatically be listed in the Employee ID field of the Hours per Employee form.

How do I accomplish this? Please provide pictures and clear steps so that I can get past this issue?

John_Foster

Hi @obprojectservices,

Do the users that submit their hours have to type in their name or do they have to log in to Smartsheet to be able to submit the form and therefore have their email in the created by column?

Thanks,

John