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

Does a view-only user need a license to use the API?
Hello everyone, I will need to use Smartsheet API to ingest data from Smartsheet to an object storage. To do that, my client will create a view only account for me. If I understand correctly, to use the API the account needs to be licensed, so we will need to pay for this "service account". That is correct?
Using Control Center to Track Folder Updates?
Hello, I am unsure of the feasibility of this goal but am hoping someone could provide some insight. Within my organization we have the following structure Workspace → Workspace → Folder. Within this folder we have additional folders that are added through an API integration we have setup. I am hoping we would be able to…
Will and API token for a report give access to the Sheet the Report generated from?
Hi, I have a large Smartsheet, I want to generate a row report that reduces information displayed down to a specific group. For that Row Report, if I were to generate an API token and share it to a third party, will that third part have access to the information on the original 'Grid' sheet, or will it be reduced to what…