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

Options
Alan
Alan
edited 12/09/19 in Archived 2016 Posts

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

     

  • JamesR
    JamesR ✭✭✭✭✭✭
    Options

    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;

    DownloadHistory.PNG

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    Options

    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

  • Galen Garrison, PMP, CSM, MBA
    edited 10/27/16
    Options

    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

  • Gwyneth C
    Gwyneth C ✭✭✭✭✭✭
    Options

    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

  • Kenyon Bajus
    Kenyon Bajus ✭✭✭✭✭
    Options

    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.

This discussion has been closed.