Best way to duplicate a batch of tasks across divisions?
We've launched a program made up of multiple projects recently and the management team wants to see all of the subtasks for those projects repeated across multiple divisions. Is there a way to templatize or repeat a group of tasks across multiple divisions or business units and keep everything in sync? Sorry I'm a bit of a Smartsheet newbie, but I'm trying to save myself from having to manually update thousands of lines in a project plan. Something like:
Project 1 - Task A - BusUnitAlpha
Project 1 - Task B - BusUnitAlpha
Project 1 - Task C - BusUnitAlpha
Project 1 - Task A - BusUnitBravo
Project 1 - Task B - BusUnitBravo
Project 1 - Task C - BusUnitBravo
Project 1 - Task A - BusUnitCharlie
Project 1 - Task B - BusUnitCharlie
Project 1 - Task C - BusUnitCharlie
Answers
-
Hey @nfields03
If I'm understanding you correctly, you already have all the rows set up across multiple sheets, but need to pull in the 3rd level rows across sheets to see them at once. Is that correct?
If so, you can use a Row Report to bring together rows from multiple sheets. You'd need to filter by a specific value to only get the 3rd level rows, then you can Group by the Sheet Name if you want to keep the tasks separate/organized but in the same view. Your users can edit values in rows directly within the Report and it will update the underlying sheet. (Note that Grouping and multiple sheets in 1 Report is only available to Business or Enterprise plans in Smartsheet).
If you meant that the sheets aren't fully set up yet and you're looking to copy/paste a hierarchy across multiple sheets, copying the Parent Row will copy all the Child Rows below it so you can easily paste them all in at once.
See: Copy and paste cells, rows, formulas, or hierarchy
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 283 Events
- 33 Webinars
- 7.3K Forum Archives