Back to search:Freelance Marketing / Indonesia
HiI am creating an excel based (currently a Google Sheet, see below) marketing calendar planner.https://docs.google.com/spreadsheets/d/1o2W9J11_JDakDcvymtsEX9qVQdMUdZz2AEYQ27h3r58/edit?usp=sharingI need either an excel whizz or programmer to help me automate some of this to create a really robust system for my team to work from. These are the kind of features I want. I assume most of this can be done in Excel but I am open to suggestions:1) I want a task list. So when an item is added to one of the rows shown in the various marketing channels a task is added to a task manager so that the users have a organised workflow list that they can sort and mark items as done2) If possible, when an item is updated in the task list, the field in the calendar changes colour so that the user can visually see on the calendar what items need to be worked on3) We will be working three months ahead of time, so we need some logic for the dates/publish dates4) A way to link various marketing elements to the key dates/campaigns in the top rows. So, lets say that we create a key date for Valentines Day, we get some sort of option to be able to drop various marketing elements onto the calendar, linked to that campaign in bulk, rather than one by oneHappy to share more information*place holder pricePS - the dozens of AI generated responses to these job posts are becoming a real issue. If you are using AI to generate your response without any real input it will be really easy to spot and I will likely not respond.