Note: You can add a third argument to the formula to exclude a list of holiday dates.

To prevent typos in the or Assignee columns:

| Metric | How It Works | |--------|---------------| | Planned vs. Actual % complete | COUNTIF on % column, compared to baseline | | Remaining work (hours/days) | SUMPRODUCT of remaining duration × assignment | | Upcoming deadlines (7 days) | Conditional FILTER or TODAY()+7 logic | | Critical path (basic) | Highlights tasks with zero total slack |

Most team members already know how to use it, reducing the "learning curve" for new tools.