Reporting changes in timelines.
Hello.. I have multiple Gantt sheets to track several project milestones, and client payments associated with those milestones. My finance team wants a monthly report on changes to those milestone payments caused by delays in the project in order to forecast revenue.
My idea is to set up a workflow that will run on the last day of every month. It will move all of the rows that have had changes made to them to a new sheet. This would allow me to keep a running total of those sheets See the example below. There are data from two different times (see modified column - varies by 2 minutes, not a month for this example). Highlighted yellow is the first timepoint, Highlighted blue is the 2nd timepoint and the red finish dates have changed.
I need to report the delay for milestone payments. For example - in this example Milestone 2 is delayed from 11/30/22 to 2/1/23. This would need to be specifically flagged. I will need to repeat this next month.
I tried using the baseline variance function, which showed the delays, but it would not allow a comparison from month to month to highlight those changes. I need to be able to do this across multiple sheets and hopefully roll this into a single report. I hope this makes sense.
Help Article Resources
Check out the Formula Handbook template!