I have built a portfolio of projects and I want to create an additional project within the portfolio to capture action items that need to be completed before some of the tasks in the related projects could complete. Example, I'm making ice cream and I have three projects in the portfolio:
Vanilla
Chocolate
Strawberry
I want to buy ONE ice cream freezer that each of the projects will use. I want to make sure the freezer acquisition and installation completes before the first batch of ice cream completes in any of the individual projects. I know silly example, but hopefully helpful.
Is there a way to create cross project dependencies so that I can align the key components (i.e. Uber Critical Path) across the entire portfolio? I don't have many interdependencies, just a few, but critical all the same. Thanks in advance for your advice!
Currently in Smartsheet dependencies and predecessors are specific to each sheet and cannot be linked across multiple sheets. (Please submit your feedback about thisto the Product team, here!)
However you could potentially create your fourth sheet, thenuse a Reportto bring together the specific critical tasks from all four sheets, Sorting the Report by the Start Date and looking at it in a Gantt view. Although the tasks wouldn't be directly linked or able to automatically adjust across sheets, this would offer you a condensed view across all your projects. I hope that helps!
Currently in Smartsheet dependencies and predecessors are specific to each sheet and cannot be linked across multiple sheets. (Please submit your feedback about thisto the Product team, here!)
However you could potentially create your fourth sheet, thenuse a Reportto bring together the specific critical tasks from all four sheets, Sorting the Report by the Start Date and looking at it in a Gantt view. Although the tasks wouldn't be directly linked or able to automatically adjust across sheets, this would offer you a condensed view across all your projects. I hope that helps!
I was afraid of that. I did submit my feedback to the product team and I think your idea of a report is the way to go. Thanks for your input!! Have a great day! Patti
No, they did not. What I did was create a task "Ice Cream Freezer Acquisition Complete" in each of the other projects and then used the "link to another sheet" to pull in the completion date from my Ice Cream Freezer project.
I have the completion tasks in the other projects depending on the created task mentioned above. Almost too simple, but it works. What I can't see though is the uber critical path via Smartsheet. I have Visio drawings that I refer to to help identify the impact of slippage risk. I hope this helps!
Thanks you@PattiLI will try this workaround for one of our programmes.
It is shocking to see that there have been enhancement requests for cross-sheet dependencies as far back as 2018, and yet nothing has come of that. It is impossible to manage project programmes without considering inter-project dependencies.
The answer is YES. You can use \"Send as Attachment\" feature in the File menu of your sheet to setup the schedule for your need. You should be a licensed user to use this feature as well (I remembered that). <\/p>
Genevieve P. Employee Admin
LPelser ✭✭![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/G1SDKXPQ7I1D\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
