Hey there! I have an automated status report that goes out every Friday containing our top 10 projects and a text status update. Essentially we use a custom field for the text status update and we enter in an update in line on the report. Every week this report should change as long as the PM has updated their text status.
If an exec would like to have a way to pull a previous report from a dashboard, is there a way to set a prompt by the date of the previous generated automated report, maybe by the week or an "as of" date?
I think this would end up being a different report.
If you have not yet set it up, you would set up your custom field to be "tracked" (setup / interface / update feeds). After you've done this, you'll be able to create a journal entry report that will pick up the changes to this field, and what date they were made.
Unfortunately, if the field has never been tracked, you would not be able to pick up past changes.
Hi! Luckily we have been tracking to the project so it should be in the update feeds. So now I just need to research how to create that journal entry report. Thank you so much for this direction!
consider ourExecutive Status Report, which leverages that technique to highlight status trends over time
alternatively, consider using our optionalBatch Processingoption to automate and upload a PDF of ourProject Status Reportsolution (or something tailored to suit you) for every filtered Project of interest at some regular cadence (e.g. weekly) so that your execs can then simply browse to the historical version of interest and examine it, exactly as it was at that time
