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 here) but the PM has to update the color status (via field on a custom form) for each project's current week, last week, two weeks ago every time they do the status report (weekly). This invites error, and also removes all history of this field for historical reporting.
On at least the 1 page per project, we want the last three weeks of this field, but only the past week of some fields (Some text fields and such).
Any help would be appreciated. Thanks.