Making bulk changes to a Sheet in multiple Workspaces

Richard Heath · 06/12/19

As an Admin for a Project Management firm I deploy a new Workspace as new Projects come online. Within the Workspace, Sheets feed Reports which feed the Dashboard. Each Project is a self contained Workspace.

Occasionally, a formula error is picked up in one of the sheets by our users. This typically means that the same error occurs in all the other Workspaces. Normally, I then correct the error in the the "Template Workspace" that I roll out and then go about manually correcting each of the live project Workspaces. Very time consuming.

Is there a way in which I can Save the Template Workspace so that each Project Workspaces remains independent, but any errors I identify can be quickly correct and rolled out via the Template? I assume this isn't possible.

Thanks

Richard.

Andrée Starå · 06/12/19

Hi Richard,

Unfortunately, it's not possible natively at the moment, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

Two workaround options that might work:

Smartsheet Control Center https://www.smartsheet.com/product/control-center
Smartsheet API https://developers.smartsheet.com/

Would any of those options work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Richard Heath · 06/14/19

Hi Andrée,

Thanks for that.

I think the Control Center could be the way to assist with this deployment.

I'll continue to investigate.

Regards,

Richard.

Andrée Starå · 06/14/19

Excellent!

Happy to help!

Best,

Andrée

Making bulk changes to a Sheet in multiple Workspaces

Comments

Categories