I am trying to make an employee sign in sheet that can automatically be updated each day. The supervisor's name is a drop box and they can single select the foreman. I want the "Name" column to update automatically the names that are associated with each foreman from the second screenshot. The sign in sheet would look like this:
I am wondering if I can get it to pull from this sheet to fill:
So, if the foreman is DJ Bubolz, then find all employees assigned to him and put on the sign in sheet.
Help Article Resources
Check out the Formula Handbook template!