If I create an automated workflow on a sheet, can that be automatically copied to multiple sheets?
![mmclaughlin](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
Or, will I have to manually add that workflow to each sheet?
Background - I want to set an automated workflow reminder whenever a date is past due. Easy enough. However, we have 73 individual Project Manager sheets that I need to create the same workflow for. I would prefer not having to open 73 sheets and manually create 73 workflows.
So, is there a way that Smartsheet will automatically copy the workflows by selecting the sheets I want it copied to?
Best Answer
-
That really stinks then it sounded like you already had them in use so it was a long shot. I use a lot of automations to my knowledge there isn't anything that allows you to deploy across multiple sheets with one or two clicks. It would be really nice if they had a feature that would manage all of the automations including deployment/updates to live sheets.
Answers
-
Not sure if you already have the 73 sheets created and in use but I typically create a template sheet that contains all your formula's and automation's. Then as I need it I simply use the "Save as New" feature which creates an copy of that template including the automation's and formula's. Hopefully this helps.
Here is a quick snip of some options.
-
@Cory Page - thank you for the response. That will definitely work moving forward, but unfortunately, the 73 sheets are already in use. Was hoping there was a bulk update feature.
Thank you, though. Appreciate it!!
-
That really stinks then it sounded like you already had them in use so it was a long shot. I use a lot of automations to my knowledge there isn't anything that allows you to deploy across multiple sheets with one or two clicks. It would be really nice if they had a feature that would manage all of the automations including deployment/updates to live sheets.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives