Historical Project Status
I would like to create a historical Project Status report. Realizing that data is live I was thinking that I could possibly create child records per month that would calculate the status at the time ...
Forum Discussion
You might get similar functionality by turning on the "Track Changes" button for the status field. This functionality prepends the status field with the date and user every time the field is changed.
Now this makes the field look a little unsightly in display forms and reports because it shows the history within the field, BUT you can just create a formula field called "Current Status" that grabs the latest status. And use this field to display in the View form and any Reports. This is done with: Trim(Right([Status], "]"))
Now then, to get the similar functionality for your , you can create fields for every status, say you have New, In Progress, and Complete, you could have 3 fields that would be a formula date field to track the date the record was changed to that status.
Now this makes the field look a little unsightly in display forms and reports because it shows the history within the field, BUT you can just create a formula field called "Current Status" that grabs the latest status. And use this field to display in the View form and any Reports. This is done with: Trim(Right([Status], "]"))
Now then, to get the similar functionality for your , you can create fields for every status, say you have New, In Progress, and Complete, you could have 3 fields that would be a formula date field to track the date the record was changed to that status.
I'm sorry, it's actually called "Log entries", not Track Changes
