Apr 13 2019 05:19 PM
I'm trying to make a work schedule. I have a spreadsheet with all shifts and a calendar style. I'm trying to find a formula to enter values into the calendar.
This is what it should look like, I've manually entered values into the calendar spreadsheet. For instance, when I enter an 8 into C3 on the top spreadsheet, I want KL to be automatically inserted into B5 on the lower spreadsheet. Is there a formula that I could enter to accomplish this?
Apr 14 2019 06:27 AM
@chescott80 , what is the formal logic behind, why in B5 and not in C5 or B6? Same for others. And layout for Monday is fully different from one for Sunday., what is the logic for this?
Apr 14 2019 07:05 AM
Apr 14 2019 07:13 AM
Apr 14 2019 07:50 AM
So, logics for the weekday and weekend is different. If for weekend initials for the 8 in second column (C) goes into B5 (I guess next column into C5, etc.), when for the Monday initials for the 8 in second column for the day are in F4, not in E5 if do that similar to Sunday.
And do you have exactly the same number of columns for every day?
Apr 14 2019 08:59 AM
@Sergei Baklan Here is an example of a full week, both spreadsheet and calendar
So, Column B=B9, C=B5, D=C5, E=D5, F=B6, G=C6, H=D9, I=F4, J=G4, K=F5, L=F6, M=F7, N=F8, O=G8. Weekdays have same shifts, Weekends have same shifts.
Apr 19 2019 05:53 AM