Hi there, I’m looking for help figuring out a formula for a column that will count the number of active projects per a project lead that are due within the next 7 days. So something that follows this logic:
IF the PROJECT LEAD is “Amanda”
THEN count Amanda’s project’s with STATUSES of “In Prep”, “In Production”, “In Post Production” that have a FINAL DELIVERY DATE within the next 7 days.
Any help solving this would be greatly appreciated, thank you!