This is something that I’d easily do with a sheet. Given that my experience with databases is limited, I would like to know what you recommend, it’ll probably have to be done with an automation, but I honestly don’t know what.
Let’s say I have 3 channels, based on the channel, the upload frequency for new videos changes. Sometimes, I have less or more time to edit, which forces me to change my upload frequency on the go.
My assistant needs to know when he has to upload. This is “Last Publish Date” + “Duration”, the duration is automatically pulled from the first table.
Now, I know that it’s not possible to have a formula in the column that says “Take previous row’s publish date and add this rows duration”, but that’s actually what I’m looking for -> incrementing a given column.
Looking forward to your replies!