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.


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    How are you currently recording when they update?

  • @Paul Newcome I dont track when they update. Each Thursday at 5pm, I presume all the PM's have updated their schedules to Thursday. In tools such as MSP or Primavera P6 the data date (also known as status date) of a schedule is shown as metadata next to the file name. This is the date I want to see for every schedule (or sheet). I then want to pull in these data dates into a graph or report and then see which schedules dont meet the lates data date (which should be the most recent Thursday).

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You are going to need to insert a date type column into each sheet and then set up a record a date automation set to trigger when the field(s) in question are updated.

    You can then create a report that pulls in each of the different sheets and set a filter to only show rows where the recorded date is more than 7 days in the past.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!