Making bulk changes to a Sheet in multiple Workspaces

Richard Heath

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å

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:

1. Smartsheet Control Center https://www.smartsheet.com/product/control-center
2. 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

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å

Excellent!

Happy to help!

Best,

Andrée