Bulk Report Update

Has anyone come across a way to update the criterial for multiple reports at once? We have several reports that all draw from the same set of sheets. Every time we start a new project (and thus create a new sheet), we have to go to each report and attach the new sheet. This is tedious and time consuming.

I've even tried to find a work around through the API. But I can't think of a way to do this either there or in Smartsheet itself.

Any ideas would be welcome.

Find more posts tagged with

API and Developers

Reports

Enhancement Request

Comments

Mike Wilday

Have you tried creating a workspace? If you put all of the sheets in a single workspace, you can choose on the report to include all sheets in the workspace. When you add an additional sheet to the workspace it will automatically be included.

See my screenshot on how selecting the workspace will automatically include all new sheets.

Paul Newcome

The same can also be done at the folder level with multiple folders (or workspaces) selected. I don't have any of that fancy GIF stuff that Mike does, but it works the same way except you would click on the appropriate folder(s) instead of the workspace(s).

Mike L.

I'm using workspaces the way that Mike suggests and it is great. I can drop in new sheets and all reports update automagically.

The only downside is workspace permission management. Every time I create a new workspace I have to create sharing permissions to the new workspace. I'm at 37 workspaces now but I have many projects still in folders. If I move them all into individual workspaces I'm not sure if I can keep up.

Edit: when I try reporting from a folder it only uses the files in the folders that were present when the report builder was setup. New files are not picked up by the report unless I specifically reselect the folder in the report builder. Also I can't set custom permissions at the folder level. Another big issue for me.

Paul Newcome

I'm using workspaces the way that Mike suggests and it is great. I can drop in new sheets and all reports update automagically.

Awesome! Glad you were able to find a working solution.

That can most certainly be a lot to keep up with.

Which puts you right back where you started... Sorry about that. I should have tested in more depth.

Also I can't set custom permissions at the folder level. Another big issue for me.

I hadn't thought of that aspect. It could be set at the sheet level, but from the sound of it, that would be WAY too much work.

lmarchisio

Thank you all for your suggestions. These are all workable, just requiring some reconfiguring of our file structure.

thanks!

Paul Newcome

Happy to help!

Sign in to join the conversation!

Quick Links

Trending discussions

what is the cause of "Unexpected character encountered while parsing value: <. Path '', line 0, pos"
what is the cause of "Unexpected character encountered while parsing value: <. Path '', line 0, position 0." error when using the C# SDK. the full log message is: - 2025-09-18 09:58:54 *** Exception in 'ProcessShares(Entity, EntityName, EntityId, Counter, ssWorkspace)' 2025-09-18 09:58:54 1 'ShareResources.ListShares()'…
Update Columns API Possible Bug - unable to clear all options in a MULTI_PICKLIST column
NOTE: I tried to file this several times a support ticket, but the AI BOT was unable to create a ticket and the OG Support Portal no longer allows the direct creation of tickets. Grrrrrr. ISSUE: It appears that the Update Column API PUT https://api.smartsheet.com/2.0/sheets/{sheetId}/columns/{columnId} fails to work as…
How to access the new end points via SDK
We were using python SDK to access smartsheet API's. Have seen most of the end points getting deprecated and provided new end points. Its providing the request with all params using direct API request in documentation. However no reference provided for using python SDK/other SDK's to access the API. Is Smarthsheet API…