The native "Every day, if due date has passed and status isn't Done, notify someone" recipe covers the basics, but after digging through dozens of community threads I keep seeing the same three walls:
1. No escalation tiers — it pings the same person every day. There's no "day 1 assignee, day 3 manager, day 7 director" without a helper column + separate automation per tier.
2. No consolidated digest — 20 overdue items means 20 separate pings, not one summary.
3. "Last Updated" doesn't count comments — so "no activity in X days" triggers miss items where the only activity is in the Updates section.
I'm a developer and I've built a small board view that handles #1 and #2 (multi-tier, day-based escalation + one daily digest), working in my own account now. Before polishing it for the marketplace I want a reality check from people who live with this:
— Which of the three gaps actually costs you time every week?
— Would you (or your admin) install a marketplace app for it, or is the native recipe + helper columns "good enough"?
Honest answers either way are gold. If the answer is "native is fine," that saves me months.