Making a copy of several sheets, reports, and dashboards
I have a workspace which rolls up multiple project plans and RAID trackers, into reports and then into a dashboard at project and portfolio levels with varying data widgets. I want to use this overall as a project template however I am noticing that when I try to save as new or duplicate the folder structure and underlying sheets, reports, and dashboards, the links do not always remain between the sheets ⇒ reports ⇒ dashboards but instead keep the old source which I then need to point to the correct source. Does anyone have any experience or solutions to make this process more efficient. For those who are superusers, I have created a manual version of what Control Center does with automation.
Best Answer
-
I have similar setup and use the PMO Project Management Office template (with customizations). It works well for reporting a dashboard and reports for all projects in the various department folders. In my case, I only use one Project Office workspace which is linked to a Project Files workspace that has all of the department level projects. I don't have a need to create multiple Project Office dashboards.
Answers
-
Check to make sure Newly Created Sheets is checked when doing Save As.
-
Thanks, I did see that part but for Reports and Dashboards it does not offer that option.
-
If all reports and dashboards exist in a folder, then copying the folder will maintain the relationships of the reports and dashboards to the new folder. It's a different story if they don't exist in the same folder.
-
Thanks. Any recommendations if they do not exist in the same folder?
-
I'm not certain. I think there is something in Enterprise Version or Control Center that helps with updating across folders.
-
Hi,
I hope you're well and safe!
As mentioned, save the folder, but it also works with a Workspace.
Would that work/help?If not, can you elaborate?
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Daniel Miller PMP You can also "Save as New" an entire workspace so long as it does not have more than 100 assets (sheets, reports, and dashboards - folders/sub-folders don't count towards the limit but structure will be maintained).
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thanks all for the help! My Workspace has 10+ different folders (each for a dept). Each folder has a sheet (project plan), several reports, and a dashboard. Copying this dept folder works ok to maintain the all the report and dashboard links. My challenge is when I want to copy a portfolio reports and dashboard which exist in the workspace level. I cannot find a way to maintain that connect and it seems like I have to repoint all of the project plans and reports to the portfolio level reports and dashboard. Any suggestions would be appreciated.
-
I have similar setup and use the PMO Project Management Office template (with customizations). It works well for reporting a dashboard and reports for all projects in the various department folders. In my case, I only use one Project Office workspace which is linked to a Project Files workspace that has all of the department level projects. I don't have a need to create multiple Project Office dashboards.
-
Thanks!
-
Happy to help!
✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives