How can I merge two schedules for a project into one all-encompassing schedule?
Hi Everyone,
I am working on a project that consists of two schedules, and there are tasks that will be done onsite for products being built for our company here in the US and for a location overseas (to be shipped out later on in the schedule). We have a schedule planned out for the US location, a separate schedule laid out for overseas, and need to combine the two into one all-encompassing schedule to we can track progress on tasks for both locations. Is there a way to do this in SS? I tried utilizing the DataMesh app but kept getting error messages when I'd run it saying it wasn't successful due to conflict with dependencies/predecessors on the sheets. I also tried using the Calendar App and got one schedule loaded up successfully, but couldn't figure out (if at all) how to add in the second schedule. My project contains confidential data otherwise I would include a screenshot of what I'm talking about. I hope my description is enough to convey my question to you all and I'm hoping someone can help me with this. Thank you!
Answers
-
Hi @Bradhickswa
I hope you're well and safe!
Have you explored using a Report to combine the sheets?
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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.
-
Hi @Andrée Starå ,
I did think of combining the two sheets into one report, which would be fine for viewing on a Calendar, but we have technicians that rely on the sheet to "check off" tasks as they complete them. I also have it set up where they can switch to Card View and keep track of all the tasks assigned to them. Is there a way to still be able to encompass that?
Thank you,
Brad
-
Happy to help!
Yes, they can still complete tasks, and Card View was released for Reports recently, so that should also work.
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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.
-
I created the report combining the two sheets, however, there are some repetitive tasks for each location that need organization. Also, it looks like the report didn't carry over the predecessors from the original sheets. I also assigned tasks to individuals which didn't carry over either.
-Brad
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives