How to create a schedule for several teams that rotates weekly?

Topic Labels: Automations Collaboration
344 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi! So here's my problem: I manage an intranet platform for a very large company and I use Airtable for our editorial calendar. There is a special section on my platform of regularly scheduled content that is user-generated. There are four business areas (mine makes five) and together we are responsible for providing this user-generated content on a rotation each week. So each week there are four slots available but five business areas. So how do I create a scheduled rotation so that each business area gets a regular number of slots and that the total number of slots for each business area is more or less equal at the end of the year? Super basic example below:

Week 1: 1, 2, 3, 4

Week 2: 5, 1, 2, 3

Week 3: 4, 5, 1, 2

Week 4: 3, 4, 5, 1

0 Replies 0