Efficient way to make same change in multiple sheets?

PaulK · 01/26/17

I've created a Project Template that has been used for 40 Active Projects.

When I am make improvements to the Project Template (e.g. Added Column, added Row, Dropdown List change, Conditional Formatting addition, creation of shared Filter...) is there any was to propogate the improvement to the 40 active Project Sheets?

I currently have to manually make the changes sheet by sheet.

J. Craig Williams · 01/26/17

PaulK,

Short answer: No.

There are some work-arounds and third party items for things like the Dropdown List changes.

That said, let's assume there was something that could add a column to sheets in a batch mode. How would you expect the applicaton to know which sheets to update?

Just asking, not a Smartsheet employee.

Craig

PaulK · 02/02/17

The example of adding a column is a real example I manually implemented in multiple sheets in the past weeks.

Having used the Report Builder, I was wondering if there was a smartsheet utility which asks questions similarly (where, who, what, etc) to assist in multi-sheet changes.

I appreciate the NO answer rather than wasting further time digging.

Paul

J. Craig Williams · 02/02/17

I like that idea. Not sure how it would be implemented.

Craig

KB London · 02/28/17

It would certainly help to be able to change multiple sheets as once...

I have a dropdown column for several sheets and if I need to change the dropdown options, I have to do this individually for each sheet. Currently, it's manageable, but not sure how it will be once there are more sheets to change!

J. Craig Williams · 02/28/17

KB,

Richard at SBP has a solution involving Azuqua that will update Dropdown Lists across your account.

Contact him for a free one hour consult at richardr@smarterbusinessprocesses.com.

Tell him I sent you.

Craig

KB London · 02/28/17

Great, thanks for the recommendation, Craig. I'll look into this.

LGustin · 09/18/18

Has anyone found a solution for adding/editing columns in multiple sheets at once?

Thanks,

Lauren

markrecital · 01/04/19

This would be helpful for me as well. Thanks.

Welcome to the Smartsheet Forum Archives

Efficient way to make same change in multiple sheets?

Comments

Categories