We are trying to use the "going smoothly, etc..." field, or a custom field, as a Red-Yellow-Green status in a weekly report of all projects. There would be both a 1 page report for each project and an overall status of all projects with less detail.
We have similar reports now (built before I was ...