How I fixed submittal register revision mismatches on a commercial project

This came up during a commercial construction project tracking submittals across architect comments and subcontractor revisions. The problem was not dramatic at first: the submittal register showed approved status while the latest drawing revision still had comments. I suspected the project engineer forgetting to update status, especially because it happened when the subcontractor uploaded a…