Here is a use case that unfortunately handled in Excel right now, but I would like to move it to Fogbugz.
1) As an insurance company, we have a small team of 3 "compliance" people that make sure that we have filed the necessary reports and paperwork in each state that allows us to do business there. There could be reports due weekly, daily, and yearly, and there are probably about 500 reports each year that need to be completed in various states.
2) The users that generate these reports are geographically dispersed FB users and aren't aware of the due date of each of these reports until they're notified by email from the compliance team, but since it's currently in email, the team never knows where each report stands within the process.
3) The team currently wants to put the 500 reports into FB and assign them to the end users, but it would then be up to the end user to set the "do later" plug in for the report. They would received, say, 80 reports in one day and be tasked with setting the "do later" for each. This would be a large burden for the end user.
4) Instead, the compliance team should be able to enter the FB case for a report, along with a "do later" date that it would be activated for a particular user a week before the report is due (or pick the amount of lead-time for each task). The compliance team would be able to see the entire universe of reports, and the FB users responsible for generating these reports would only get notified of a new case for a report a week before it was due, even though the compliance team may have entered the information a long time ago.