So I've read and downloaded about 4 of the calendars user Pete_Uk has created but am having a tough time transposing my data into them.
My wife is a romance author and I do all of her marketing. One of the key components is ad stacking i.e. multiple ad sources stacked on the same day. So it's very important to visualize what is happening on what day so everything comes together.
I've attached a spreadsheet with some sample data and its pretty basic: Which book am I promoting? Where am I promoting it? And what date?
Then I'd like to have three calendars for current month, next month, and month after which is about how far out I plan the ads.
I've also made a formatting table which helps to easily visualize which books are stacked on which dates. I will probably just archive the old data for my records in a separate tab once the list starts to grow so no need to worry about anything other than the current month + next two months at a time.
Is it possible to apply formatting like I have done manually? And if so can I add to that formatting list moving forward?
Bookmarks