Hello forum - have been beating my head against the wall on this for some time, hoping someone has some advice!
Currently our intake process is as follows:
- Requestor fills out our intake form. The form submission becomes a task in our creative production project.
- Rules apply a list of subtasks based on the channel they’ve selected and conditions i’ve highlighted (ie: email has a list of subtasks that is different than social media, social media is different than paid ads, intl users have different workbacks than us users, etc).
- The task is assigned to me so I can finish processing it.
What Asana seemingly cannot do for me right now, or what I cannot figure out, is the following:
- utilizing the parent task due date, calculate backwards from that date to determine when each subtask would need to be completed. ie: R1 copy is due 15 days before the due date, R1 design is due 13 days before the due date, etc. From what I’ve seen right now, the automations in place can only go FORWARD from the due date, not backwards.
- note: the assignee is not always the same, but the allocation of time for each subtask is always the same.
- Parse the ticket description to add collaborators automatically (I currently have to do this by hand)
- Assignees have to be done by hand - I can’t set it to read the description and know when the DRI is ___, assign all corresponding subtasks to that person.
I’m currently facing a backlog of over 300 tasks (with due dates spanning the next few months) and the thought of continuing to do this manually is exhausting. My manager does not want me spending all of my time as a ticket taker.
I tried using Flowsana to see if this would work, to no avail (I’m either not getting it, or I would need to invest a good bit of time to overhauling my workflows to make it work for me).