Why HubSpot's "Next activity date" filter lies
The obvious play is to open your deals view and filter by Next activity date is unknown. It's one filter, immediately useful, and HubSpot puts it right in the dropdown.
The problem: notes_next_activity_date is one of the most fragile fields in the entire HubSpot data model. It updates when a task, call, or meeting is scheduled — but a few common situations distort it:
- Sequence emails can populate it with future "send" timestamps even when there's no human action planned.
- Overdue tasks that nobody closes out keep the field looking populated, even though the rep effectively ghosted.
- Tasks scheduled but never completed get re-counted on every dashboard refresh — the field looks "fresh" while the buyer is going cold.
The HubSpot Community has been flagging this since 2019. The accepted view (Next activity date is unknown) catches the most flagrant cases but misses the deals you most need to find — the ones where the rep created a task three weeks ago, never completed it, and hasn't logged anything since.
What three signals together actually catch
Three signals in combination:
- No upcoming task, call, or meeting scheduled in the next 30 days.
- Last activity > 7 days ago — confirms the deal isn't quietly being worked.
- Open deal stage — closed-won and closed-lost don't count.
A deal that fails all three is a deal nobody is working. That's the cohort that loses you money.
Why a clean filter still requires a custom property to be reliable
To do this properly in HubSpot, you maintain:
- A custom boolean property (
deal_has_open_taskor similar). - A workflow that updates it on every task-status change.
- A daily-running scheduled workflow that catches deals where every associated task is overdue.
- A separate filtered view for each definition of "stuck" your team cares about.
Three custom properties, two workflows, four saved views — for one question. And every time HubSpot tweaks how notes_next_activity_date calculates, you re-validate the chain.
The manual HubSpot recipe
The native filter catches the flagrant cases. The custom-property layer catches the subtle ones. The combination is what makes this rule reliable across portal changes.
- Open Sales → Deals → Create viewNavigate to Sales → Deals. Click 'Create view' in the top right.
- Add filter: Deal stage is not closed won/lostFilter by Deal properties →
Deal stage→ 'is not any of' → 'Closed Won', 'Closed Lost'. Open deals only. - Add filter: Next activity date is unknownAND group →
Next activity date→ 'is unknown'. The native HubSpot field — flawed but the only direct signal of 'no scheduled touch'. - Add filter: Last activity date is before 7 days agoAND group →
Last activity date→ 'is before' → 7 days ago. Combination: nothing scheduled AND nothing recently happened. Stronger signal than either alone. - Save as 'Deals — No next move'Pin to your sales-ops dashboard. Review weekly with each rep on their flagged rows.
- (Optional) Build the human-touch helper propertySettings → Properties → Create
deal_has_open_task(boolean). Workflow: when associated activity of type Task with status Not Completed exists, set true. Filter your view ondeal_has_open_task = falsefor the more reliable signal.
What Bloated does instead
Deals nobody is planning to touch — sequence noise and stale tasks excluded.
Bloated separates real human-planned activity from sequence-driven and orphaned-task pollution — so the cohort surfaced is genuinely the 'nobody is working this' pile. Cross-references logged activities, scheduled tasks, AND scheduled meetings for a complete picture. Pair with the suggested action: schedule the next touch, escalate to manager, or mark lost with reason.
notes_next_activity_date · HubSpot deal property