Recording Status changes throughout the course of a project
Hello,
I want to record the change in the status of a symbol column. I understand that there is a "record the date" automation in place, but this automation gets rid of the previous date that the record was changed. I want to display on a dashboard every time the date has changed and what symbol it changed to. Please let me know if there is any workaround for this issue.
Thank you and have a great day!
Best Answer
-
Hi Adam,
For logging changes on a particular sheet, I use an automation that copies the entire row to a different sheet used to log the data changes. The automation is triggered whenever a row is modified or added. One of the columns I have in my main sheet is a system column called Modified and the column type is "Modified Date".
I then use reports or cross sheet links to create the view of the data that I want from the log file.
Hope this is helpful for you and have a great day.
Tom
Answers
-
Hi Adam,
For logging changes on a particular sheet, I use an automation that copies the entire row to a different sheet used to log the data changes. The automation is triggered whenever a row is modified or added. One of the columns I have in my main sheet is a system column called Modified and the column type is "Modified Date".
I then use reports or cross sheet links to create the view of the data that I want from the log file.
Hope this is helpful for you and have a great day.
Tom
-
Hi Tom, which is the automation you used to copy the entire row to a different sheet used to log the data changes?
Could you provide more details?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!