Library › Leadership AI › Project managers
Mark overdue actions in a CSV using today's date
- For Project managers
- You practice Catching mistakes and made-up facts
- Time about 5 minutes
- Level Intermediate
About this exercise
Today is 2025-04-14. Convert the action list to a CSV in one code block with the header id,owner,due,status. Status is overdue if the due date is before today and the action is not done, done if marked done, otherwise open. Use the latest status in the notes. Sort rows by due date, earliest first. At most 7 lines inside the block and nothing outside it.
Common mistakes when you ask AI for this
- Ignoring the update. The AI leaves A3 overdue. Try: Say: "Apply the updates: A3 is done."
- Marking today as overdue. The AI marks A4 overdue. Try: Say: "Due today is open."
- Wrong sort. The AI keeps the original order. Try: Say: "Sort by due date, earliest first."
- Extra text. The AI explains each status. Try: Say: "Only the code block."
- Extra lines. The AI adds a totals row. Try: Say: "Header plus six rows only."
What a strong prompt includes
- Header
- Today
- Sort
- Status rule
- One block
Related exercises
- Alert sales to a competitor's price change, facts only (Research & AI Search · Product managers)
- Announce a schedule change in a text message under 45 words (Leadership AI · Small business owners)
- Announce a team split with empathy and only the facts (Leadership AI · Managers and team leads)
- Announce a tool migration in Slack with exact dates and no jargon (Leadership AI · Managers and team leads)
- Answer staff questions about a 4-day week pilot honestly (Leadership AI · Small business owners)