Be aware of upcoming changes to the Sheet Access and Published Items reports in Admin Center
We wanted to share some details on upcoming changes we will be making to the Sheet Access and Published Items reports in the Smartsheet Admin Center.
Today, these reports can be time-consuming to generate and contain thousands of rows, making them difficult to consume.
To improve the experience and enable additional automation we will be:
- Removing asset and workspace names from the Sheet Access & Published Items reports and making this information retrievable through the new resource API URL and resource ID fields, so your admins can automate the retrieval of the desired information.
- Removing the owner field from both reports and making this information retrievable through the new permissions set name column in the Sheet Access report, which will list each user or group and their shared permission.
These changes will go into effect on December 5, 2023.
With this change, admins may need to create scripts to consume the data within these reports – and sample Ruby scripts will be provided as a reference. SysAdmins without the required expertise or access to programming tools are advised to work with their IT teams to create the necessary scripts to parse the report data.
Please note that you will still be able to view the shared to email addresses in the new Sheet Access report as well as the publishing user email addresses in the new Published Items report without any custom scripting.
You can also stay informed by subscribing to receive product release updates.
The Smartsheet Product Team