Hi all!
I'm the product team for a company that produces physical goods (apparel and hard goods). For each new product launch we have multiple phases and deadlines we need to manage: briefing due date, design due date, sample due date, PO date, etc (14 milestones in total). We are managing across dozens of new products at all times and want a way to track our progress through these, not just to list out the phases and deadlines.
I've built out our airtable to show the due dates for each phase against each product (see screenshot below), now we're looking for a way for our team check off when a phase is complete and have that visually indicated to us -- for instance have the cells with deadline colored to gray when complete, but also colored to green when due date is within a couple weeks and red when due date is past.
We're relatively new (and not yet super sophisticated) airtable users -- so would love whatever guidance you can provide. Thanks!