Running a report - Keeping old data to compare
Hi Team,
I want to set up a report that will allow me to pull values from a column at a certain date/time, then within that same report, for that same column, pull the values a later date/time so i can compare changes. Is this doable?
When i create report and link it up to the columns i want, it is all live. So if someone makes a change in that column, the report is updated automatically with the new value and the only visibility i have of the previous value is if i go to cell history.
Thanks for your help in advance!
Answers
-
The only way it is doable is if you create a copy workflow to copy the row of data into another sheet when a change happens to the cells in the columns you're interested in. You will then create a report from your live sheet to look at latest data and another report from the copied sheet to look at previous data. You will need to a few helper columns to identify the immediate previous entry and have the report filter based on the helper column. You will still not be able to see the first change made, as the copy happens after the change is done in your live sheet.
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!