Each Project Owner is responsible for updating the columns each week.
This dashboard view is automatically updated, with data feeding into it from each project’s individual page.
If the status changes, they will need to delete and re-color the text, and type in any updates to the other fields.
The status and its color-coding are updated automatically. Formulas determine how many tasks are completed, and label any project off-track.