Each phase has a bunch of different tasks. For example, the "Prep" stage has each of these tasks:
Create Flower Recipe Rent Van/Transport Book Accomodations Finalize Hardgood Counts Order materials for special mechanics Digital Mockups Final Call Create Timeline Submit Flower Order Prep Hard Goods Adjust Packing List
All of these tasks in each phase need to be repeated for every event. And each of these tasks has a deadline range relative to each event. (submit flower order needs to be done between 21 and 45 days before the event). I am fine setting a single deadline for each task, but the deadline depends on the project date.
Right now I have a table for Projects, and a table for tasks, but I'm really struggling to come up with due dates for each task per project. And I'm struggling with how to move each task within phases.
We have three different team members, and any team member can do any aspect of each- but it would be awesome if any user could take "ownership" or mark that a specific task is in progress, or waiting, etc.
I'm so excited about airtable! My brain is just very visual and I can't figure out the formulas to work around this
Hi @MeganLW, If your company has a budget to hire an expert Airtable consultant to form a long-term consulting relationship with, please feel free to contact me through my website: https://www.scottworld.com/airtable