Asana Project Health Audit From an Export
Find overdue, unowned and stuck work in a project.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
Audit this Asana project using the export: [PROJECT_EXPORT] with fields task, assignee, due date, completed, section, created date and last modified. Today's date: [TODAY]. State your thresholds before counting, for example overdue means due before today and not completed, and treat tasks with no due date separately since they cannot be overdue. Calculate total tasks, completed share, overdue tasks (count and share of open), tasks with no assignee, tasks with no due date, tasks untouched for more than 30 days, and the oldest open task. Show the arithmetic and the sample size, and warn if the export seems truncated or lacks a field you need. Group overdue tasks by assignee and section to show where work is stuck. Rate the project healthy, needs attention or at risk, with the rule you used. Return a table of findings, a clean-up list (tasks to close, reassign or reschedule, each needing the owner's agreement), and three process changes to prevent the same problems. Do not suggest deleting tasks.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.
See an example result (fictional data)
Invented export of 120 tasks. Completed 66 (55 percent). Open 54. Overdue 18 (18 / 54 = 33.3 percent). No assignee 9. No due date 14. Untouched over 30 days 11. Oldest open task: 142 days. Rating: needs attention (rule: over 25 percent of open tasks overdue). Clean-up: reassign 9, set dates on 14, ask owners about 11 stale tasks. Estimated time 90 minutes. Reading: one in three open tasks is overdue, but the 9 tasks without an assignee are the first thing to fix because nobody can be asked about them. Quick wins in the first 30 minutes: assign the 9, set dates on the 14, and send a list of the 11 stale tasks to their owners. Next audit: repeat in four weeks and compare the overdue share, now 33.3 percent.
Illustrative only, made-up data. Your results will differ and must be reviewed.