Check 30 schedules in large portfolio for correct progress updating
I need some ideas how to track which schedules in a large portfolio of 30 projects/schedules have not been updated to Today's date. Each of our project managers are supposed to update their schedules every Thursday. Ideally, I want a report or formula or flag or something that tells me which schedules are updated correctly and which are not - most likely in list format on a separate sheet/report. Then I can call each PM and tell them to update their schedules.
Any ideas how to implement a check like this on circa 30 schedules?
I have thought about building checks in each schedule (using summary fields) for actuals in the future and 0% completed activities in the past but this will cover only some incorrect updates and not things like activities that are shown as started but with %complete not updated correctly up to Today's date.
Help Article Resources
Check out the Formula Handbook template!