Report to see what sheets a user is assigned

kent.robinson

Is there a report that shows what sheets a user is assigned to?

Ape_Man819

To see which sheets a user is assigned to in Smartsheet, you can use a Sheet Access Report as a system admin. This report, accessible through the Admin Center, lists all sheets and other items within the plan and their associated access. 

Steps to find the sheets a user is assigned to:

1. Access the Admin Center: Navigate to the Admin Center within your Smartsheet account. 
2. Locate the User Management page: You can find this by going to Users and Groups > User Roles and Reports. 
3. Download the Sheet Access Report: Look for the option to download a report that lists sheet access, which also includes reports and dashboards. 
4. Review the report: The downloaded Excel file will contain a list of all sheets and other items within the plan, along with the users who have access to them. You can then identify the sheets where the specific user is listed.