Editing multiple sheets at once

ahumne

Hi,

I've been working with over 50 sheets in a workspace. Each sheet contains info of a different country.

Now if I make a change in one of the columns in a sheet, I have to replicate the change in each of the files individually.

Is there a way to make a change across the same column in all the sheets at once?

 

Any help would be greatly appreciated.

 

Thanks,

Adarsh

Paul Newcome

I don't know much about it, but have you looked into the SS Control Center yet?

Andrée Starå

Hi Adarsh,

What would the change be?

More info about Control Center: 

https://www.smartsheet.com/product/control-center

https://help.smartsheet.com/topics/smartsheet-control-center

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

ahumne

Hi Andree,

 

Thanks for the suggestion!

Could you help me understand how can I use control centre to achieve this?

Thanks,

Adarsh

Andrée Starå

Happy to help!

If you've set up the sheets/projects with Control Center, you can do something called Global Updates that can, for example, find and replace or add/change columns and much more.

More info: https://help.smartsheet.com/articles/2476706-smartsheet-control-center-make-global-updates

Hope that helps!

Best,

Andrée

Angie M Graham

Since this question was asked in 2019, I would like to check in and see if there are any updates to this question. I am wanting to do the same thing, Update a column in multiple sheets in a workspace at one time. I would rather not have to purchase an add on such as Control Center. I HATE asking sales for pricing because it's either such a hassle to get a simple price quote or the price is so astronomical that it's not feasible. I currently have the Enterprise Plan but finding it is not much better than the basic business plan when it comes to features. I am trying to find a work arounds to purchasing add ons.