Auditing User Access and Permissions Across a Workspace

Question

Hi Smartsheet Community!

Is there a way to generate a report that provides a comprehensive audit of all users who have access to a specific workspace, including the individual sheets, reports, dashboards, and other assets within it?

Ideally, I’d like to pull a report that identifies each user, the assets they have access to, and their current permission levels (Viewer, Editor, Admin, etc.).

I'm looking for a more efficient way to review and manage access permissions without having to manually check each asset individually.

Does Smartsheet currently offer this functionality, or is there a recommended workaround?

Thanks in advance for any guidance!

COBT

Khasim · Answer

If you're a System Admin on Enterprise, the Sheet Access Report in Admin Center gets you most of the way there, and you can filter it by workspace. If not, a small API script that loops through the workspace and pulls the shares on each sheet works well, and you can rerun it monthly. Don't forget workspace-level shares cascade down, so check those first.

Ankesh · Answer

Hi @CatherineOBT2021IMGA

Could you give it a try: Sheet Access Report in Admin Center.

Requirements: Business or Enterprise plan, and you need to be a System Admin.

How to run it:

* Go to Users and Groups > Seat Types and True-up.
* Select Reports > Sheet access report.
* The report is emailed to the address you use for Admin Center.

It lists each sheet, report and dashboard with its workspace, who it’s shared to, and their permission level. Filter by workspace name and you have your audit.

Let me know if it covers what you need? If you aren’t a System Admin, then API route can be checked.

Article:

https://help.smartsheet.com/articles/2483064-sheet-access-published-items-report