Report that takes data from multiple workspaces

Corentin Dal Farra

Hello everyone,

Do you know if we can create a report that would go into all our workspace, or that each time I create a new workspace it takes it into account ? (just like you would do when you choose a single workspace, the report takes into account all sheets from the workspace).

Maybe it is possible with Control Center ?

It is very important for us as we have a workspace for each client (300) with multiple projects in each workspace, and we need to create reports that go and look for a lot of data in all client workspaces.

Thank you for your help,

Corentin

Bassam Khalil

Hi @Corentin Dal Farra 

Hope you are fine, did you mean you want to collect data for a defined client from the specific workspace using all the sheets in that workspace. 

Corentin Dal Farra

Hi @Bassam.M Khalil

For example I have 3 different clients workspace with 3 project sheets in each client workspace.

I would like the report to automatically go into the 9 project sheets.

Let me know if it is more clear,

Thank you for your help,

Corentin

Andrée Starå

Hi @Corentin Dal Farra

I hope you're well and safe!

The only way I can think of would be with Control Center or maybe the Smartsheet API.

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Corentin Dal Farra

Hi @Andrée Starå

Could you please explain me how to do this with Control Center ?

For example I have created a report that goes into the client workspaces already existing, but each time I create a new client workspace through control center the report does not take into account the new workspace created.

Thank you for your help,

Corentin