Applies to
- Business
- Enterprise
Track changes with the activity log
The activity log shows a user's activity in a sheet or who last viewed a dashboard.
Who can use this?
Plans:
- Smartsheet
- Business
- Enterprise
What you can track in the activity log
Use the activity log to track common actions:
- Who viewed the sheet, report, or dashboard
- Who’s been shared to or unshared from a sheet, report, or dashboard
- For sheets only: the type of changes made and the details. For example, On Row 4, Sally Smart changed the Status from In Progress to Complete
- The name of who made the change
- The time and date the changes were made
- Workspace sharing
Things to know about the activity log
- The activity log shows the most recent cell changes. Right-click and select View Cell History to view a particular cell's history.
- When you close the activity log, your filters are cleared automatically. You can't save or share activity log filters on the sheet.
- Some actions can't be traced back to a Smartsheet username. For example, if you access Smartsheet by clicking on an attachment without logging in, Smartsheet tracks and records the activity, but the log entry will display the username download@smartsheet.com.
- Activity logs in reports don’t provide details of the changes made. If you need to track cell or row changes in a report, go to its source sheet.
Who can view the activity log
Sharing permission level | Can view activity log | Can export activity log |
---|---|---|
Owner* | Yes | Yes |
Admin | Yes | Yes |
Editor** | Yes | No |
Commenter | No | No |
Viewer | No | No |
*Only the owner can see the sheet's creation activity. However, if you transfer ownership of a sheet, the new owner will see all the activity logs from when the sheet was created.
**Dashboards don't have an Editor sharing permission level. Only Admins and the Owner can view the activity log for dashboards.
Owners, Admins, and Editors must be paid users to view and export the activity log.
View activity log entries
There are two ways to open the activity log dialog:
- Open the activity log dialog via the menu bar
- In the menu bar, select File > View activity log.
Or,
- Open the activity log dialog via the right bar
- In the right-hand bar, select the activity log icon.
Sheet changes influenced by APIs
Some organizations create or use custom workspaces that leverage the Smartsheet Application Programming Interface (API). An example is the Smartsheet Pivot App. If the API influences the items in a sheet, you'll see the API—Integrated App image next to the date column.
Filter activity log entries
The View activity log dialog displays sheet actions, such as who deleted rows and when a user viewed the sheet. By default, the report in the activity log dialog shows the events for the last seven days.
Use filters in the activity log to see only the entries you want. For example, you can apply a filter that shows the activity for a specific date range, a specific type of action, or the specific people who have been active on the sheet.
Apply filters to the activity log
- In the activity log dialog, expand the Filters section.
- Select any of the following:
- Action: Filter the activity log by the type of activity
- Collaborators: Who performed the activity
- Date Range: The group of dates that you want to view the activity of
- Select Apply.
If you need to clear the filters, select Clear Filters.
Export the activity log
You can download the activity log for the item to keep an additional record of sheet activity. Each download is limited to 90 days of sheet activity data.
To export an activity log
- In the menu bar of a sheet or report, select File > View activity log.
- Select a start date and end date in the Date Range section.
- Optional: In the Action and Collaborators filters, select additional options.
- Select Download.
Smartsheet emails a link to the file to the address associated with your Smartsheet account.
- Select the link in the email message to download the activity log.
If a sheet name contains a unique character, you may need to remove the characters from the file name when you export the activity log's CSV. Certain symbols, such as | (pipe) or * (asterisk), cause the file to appear corrupted when opening.
When should you expect the exported file?
The time it takes for Smartsheet to generate the file and send you the download link varies. Once you select Download, you should receive a message with the link to the file within the next business day.
Request a snapshot of the sheet
If you're a sheet Owner or Admin, you can request a snapshot of your sheet's cell or column changes.
To request a snapshot of the sheet change(s)
- Open the sheet's activity log dialog.
- Adjust the start and end dates in the Date Range section as needed.
- Navigate to the specific change, expand that row, and select Request Snapshot.
Smartsheet emails the snapshot to the sheet owner in an Excel file. The file contains sheet data, a summary, and comments only. Conditional formatting, attachments, notifications, cell history, and any formulas incompatible with Excel (column formulas, @row, @cell, cross-sheet formulas, etc.) aren't supported.
You can only submit one snapshot request on any given sheet. Once the first request is complete, you can file an additional request.
Card-view-related actions in the activity log
Some actions listed in the activity log dialog describe an overall change but don't provide context on the details of that change. Below are a few actions you might see and what they mean:
- Card View: Cards Reordered: You've manually dragged one or more cards from one position to another, either to a different lane or a different position in the same lane.
- Card View: Cards Reordered Indirectly: Cards have been moved by any other means. For example, when you manually drag one card to any position in the same or a different lane, other cards are indirectly moved to higher or lower positions. Cards can also be reordered indirectly when you make changes in the Grid View and Gantt View, such as assigning a task to a different person or changing the list option for a row.