Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Activity Log
Is there an option anywhere for activity on a sheet to be logged.
ie: I would like to know who has accessed my sheets and the time/date they have accessed the sheet and also details of any changes they have made.
At the moment it sems that anybody (who has access) can make changes, make deletions, make errors, and there is no record as to when they may have done this ? I get the email updates, but one of my main reasons for using smartsheet is to try cut down on the number of emails I receive.
When my site managers update the percentage against a task on a project sheet, I would like to be able to see (maybe by just hovering over the percentage) when it was last changed and by whom.
Any thoughts on when (or if) these features could be made available ?
Regards
Alan
Comments
-
Alan
Only Editors or Admins can make changes to your sheet, Viewers can't. Change permissions to Viewer for those people that don't need to make changes.
I don't think you can tell who has accessed your sheet but you can tell who make a change. You can add a Last Modified By column to see who last changed the row. Or you can right click in a cell and View History to see who made the last change, when they did it and the cell history prior to that change.
Hope this helps.
Christine
-
If you also right mouse on a cell it will show cell history, If you have highlight changes on it will show you the cells that have changed.
Also, Account, User management, User Dropdown;
-
Alan,
A logging function has been requested before.
It is not yet on the roadmap.
https://www.smartsheet.com/product-roadmap
You can show/add the Modified By and Modified (Date) System columns - these are updated for any change on the row.
If you are only concerned about changes and not just viewing, then you can at least key off those two columns to get you close.
The other suggestions on View History and Highlight Changes is what I do most of the time.
Craig
-
Thanks for the roadmap link, Craig. I am a new user and learning as quickly as I can. It appears that this feature is WIP. It is listed as:
"Sheet History: View an audit log of changes to a sheet” is currently work in progress.
Cheers,
gg
-
We now DO have an Activity Log feature. For details on how to use the feature, please see this article in our Help Center:
Track the History of Changes Made to a Sheet with Activity Log
-
How can we view activity for a single user in all of Smartsheet? Not for just one sheet. I want to be able to see an Activity Log on a single user for all Smartsheet activity.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives