Hi Ashley,
There are always many different ways to approach a solution.
To simplify the structure and get the reports that you need, you may want to consider using 2 tables. A States table and a Requirements table.
You can relate each requirement to a State and then use summary fields to show past due, open status and closed, etc. You would create the report for this on the States table.
On the requirements table, you would create the report by functional area. If you want your managers to see these 2 reports at the same time, you can create a custom home page for the manager role and put both of these reports on it. You can add any other reports that they need too.
------------------------------
Debbie Smith
Certification Program Developer
Quick Base
Plymouth MA
2394106333
------------------------------