Google Sheet Script - Shift schedule for 4 shifts

1
votes

Im new to Gscripts, Im planning to create a Shift schedule using Gsheets. I tried a couple of scripts, but not able to find the right one.

This one is almost close, but it has only 2 shifts.

I have 4 employees and want to have 4 shifts.

  1. Morning
  2. General
  3. Afternoon
  4. Night
google-apps-scriptgoogle-sheets
I have to apologize for my poor English skill. Unfortunately, from This one is almost close, but it has only 2 shifts. I have 4 employees and want to have 4 shifts., I cannot understand your current issue and your goal. Can I ask you about the sample input and output situations you expect as the images? And also, can you provide your current script and the detail of the current issue of your script? By this, I would like to try to understand it. – Tanaike
Thank you for replying. About your replying of the link has the schedule for day and night shifts only. I want the script for 4 different shifts., I have to apologize for my poor English skill, again. Unfortunately, I cannot still understand your question. But I would like to try to understand it. When I could correctly understand it, I would like to think of the solution. I deeply apologize that I cannot resolve your issue soon. This is due to my poor English skill. I deeply apologize for this again. – Tanaike
@Tanaike, there is no need to apologize for your English skill. You are clearly understood. It's a big world with lots of languages. And you are being kind enough to volunteer your time to help others. I encourage you to help with confidence. – Erik Tyler
@Erik Tyler Thank you. I'm always worried that I cannot understand the question because of my English skill. So I was encouraged by your comment. I appreciate it. – Tanaike
If you have 4 employees and 4 shifts it means that all your people should work every single day. Are you sure that you're need a script? You can make schedule for the first day and copy/paste it to the rest days. If the schedule can not be done this way you have to clarify how the schedule should look like. – Yuri Khristich