Setup Automation Where New Status Assigns Date/Time From A Preset Rolling Schedule

[jvogelis]

Hey there! I've got a cool idea to streamline our database for easier use.

Here's a Video Demo: Database Automation for Content Publishing 🤖 | Loom

Currently, I have a content database filled with records from a form, and I've set up automation to fill out most of the fields. I'm exploring ways to automatically assign a publish date based on a rolling schedule I can pre-set. I'm looking to avoid manually setting dates and want the system to add content to the schedule automatically. 

I'm not sure if I need to create a formula for this or another table to reference back to. Let me know your thoughts Airtable community!