Modified & Create Date column
I'm trying to create a report that will show me what has been modified or created in a sheet in the last 7 days. I know I can highlight changes but I would rather just have a report show me what has changed from the sheet.
I'm running into problem with this not working correctly and I don't have the permissions on the source sheet to add columns (nor will the owner add any columns for me).
Is this due to the timestamp in the system-generated columns (Created & Modified)?
Has anyone been able to do something like this?
Any input would be appreciated.
Thanks -Peggy
Answers
-
I am pretty sure you can't pull WHAT changed, only the rows that changed. Using the system generated column of modified. You should be able to pull anything from the last 7 days.
-
I thought so too but I know for a fact one line item had multiple columns changed today and the Modified column didn't change. So I'm at a loss as to why it's not working like I thought it would.
-
Hmmm. Were the changes saved? Are the modified dates updated to today's date? Can you share a screenshot of the original sheet and your filter settings in the report builder without exposing any critical information?
-
@Mike Wilday - Ok if I email you directly?
-
Yes,. that would be fine.
-
Hi @Peggy P , I'm trying to create a similar report or add just changed rows to a dashboard. Any success?
-
No - I have a ticket open with Support. I will make sure to post what they say on this thread.
Thanks -Peggy
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 283 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!