How to track changes via a report for a single cell in a schedule?
I have a large construction schedule sheet that I will require updates to "Start" and "Finish" dates. To better coordinate with our project controller, I would like to create a report that shows modified dates within the past week. I currently have a report (see attached picture), that pulls the modified column based on the last seven days and then shows the "Start" and "Finish" columns which were added with the "Columns" button. However, this picks up ANY change made to that item which there are numerous other columns associated to that row. Is there anyway to filter the data to ONLY show when the "Start" and/or "Finish" date were modified versus any?
Help Article Resources
Check out the Formula Handbook template!