Forum Discussion
Is it possible to enter a value from column A if there is a value in column C into a different sheet
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 l...
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?
- This is just how our shifts are, weekend vs weekday. I will enter a formula for each cell on the calendar. I can't change the setup for the calendar, this is what employees are used to looking at...the spreadsheet has the actual shifts to schedule. I want to cut down on errors of manually transferring data from the spreadsheet to the calendar.
