Build a shared work tracker people can update without breaking its formulas
Your team has a spreadsheet, but one person writes “waiting,” another writes “pending,” and a third overwrites the formula that totals the open work.
Open the solution →A problem in a small team’s work
Tasks get forgotten and reminders keep coming after completion.
A teammate owes an input, but its due date exists only in a message. Another task is finished, yet a prewritten reminder still arrives. Start with one current list, a named person and an agreed date.
Why address it
Unclear status forces the team to rediscover who should act. Unnecessary reminders also compete with useful ones. The issue is whether pending work reaches its responsible person, rather than the number of notifications.
How big is the problem in your team?
For one working week, count overdue open tasks, tasks without an assigned person and reminders for completed work. Also record time spent manually chasing status. Repeat the same review after introducing the shared register; automate only if it saves more work than its administration requires.
This is a recommended measurement approach, not an estimate of an average business loss. We have no verified market benchmark for this specific problem. Your baseline lets you compare the change later.
Choose what needs to change
Internal reminders that stop when the task is done
Use current task state and suppress same-day repeats. The included script starts in dry-run mode.
Open the solution →Start with a verifiable process
An open/done/paused state and agreed date are enough to decide whether a reminder is due. An AI agent would add uncertainty without a necessary benefit. For a small volume, keep manual review or existing in-app notifications; for recurring work, use the guide with a simple rule and script.