Employee Schedule


I have a list of 4 employees who visit various sites in the course of a week.

My requirements:

  • Each week I want the system to automatically send each employee a form that they populate for each day of the week with fields - date, time start, time finish, site.
  • Example:
  • Employee Name: Abby
  • 6 June 2022 , 09h00, 10h00, Site ABC
  • 6 June 2022, 10h30, 11h00, Site BCD
  • 7 June 2022, 15h00, 15h30, Site XYZ
  • Employee Name: John
  • 6 June 2022 , 11h00, 12h00, Site ABC
  • 7June 2022, 10h30, 11h00, Site JBD
  • 8 June 2022, 08h00, 17h30, Site CPT

This form is then used to populate a scheduling smartsheet that I can filter (based on employee name or date) or site and from which I can draw reports for dashboards.

Suggestions on how best to do this would be appreciated.