Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Efficient way to make same change in multiple sheets?
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.
Comments
-
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
-
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
-
I like that idea. Not sure how it would be implemented.
Craig
-
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!
-
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
-
Great, thanks for the recommendation, Craig. I'll look into this.
-
Has anyone found a solution for adding/editing columns in multiple sheets at once?
Thanks,
Lauren
-
This would be helpful for me as well. Thanks.
