Enhancements to the Alternate Sheet Access Report and Published Items Report now generally available

Lekshmi Unnithan

Hi Community, 

We introduced alternate versions of the Sheet Access and Published Items Reports late last year to assist customers facing timeouts with the original reports due to their large size. These alternate reports replaced some columns with API URLs, which required SysAdmins to use programming tools and custom scripting to access detailed information.

We’re excited to announce a new update that adds an "Item Name" column and a “Published Item Name” column to the alternate Sheet Access Report and Published Items Report respectively. These new columns provide clear, human-readable names of Smartsheet items—like Sheets, Reports, and Dashboards—making it easier for SysAdmins to identify items without technical expertise. 

Please note that the original Sheet Access and Published Items Reports remain available and unchanged. Learn more about Sheet Access and Published Items reports.

You can also stay informed by subscribing to receive product release updates for curated news of recently released product capabilities and enhancements for the platform of your choosing, delivered to your inbox. As new releases occur, you will receive a weekly email with news of what's released every Tuesday. 

Cheers,

Lekshmi Unnithan

Senior Product Marketing Manager

MCorbin

@Lekshmi Unnithan (Hi! haven't talked to you in ages 😊)

The sample report downloads as an XLSX file. It's got formatting in it, and both ID columns (Resource ID and Subject ID) are displaying as scientific notation .

There is also a header (merged cells) that could impact our ability to manipulate the data

Could we get a data file, without formatting - CSV like the other files?

MCorbin

MCorbin

Also - the API URL results in this:

{  "errorCode" : 1004,  "message" : "You are not authorized to perform this action.",  "refId" : "hnben1"}