Hi,
Attached below is my form, on the sheet named "SEO shifts" I have a rota, on the rota the times and content remains the same but the name changes dependant on the date.
I've currently made a static list for the following weeks but the issue I'm going to face is that all I have made change is the days, so the week after the same people will be doing the same thing, so its not going to make it fair.
is there anyway that I can make the names roll every new week and then have the "current week" display what the person will be working this week?
Once you see the form I am hoping it will make sense?
Bookmarks