Cross Project Dependencies

01/06/22
Accepted

Hi SmartSheet Community!

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!

Best Answer

  • Genevieve P.Genevieve P. admin
    Answer ✓

    Hi @PattiL

    Currently in Smartsheet dependencies and predecessors are specific to each sheet and cannot be linked across multiple sheets. (Please submit your feedback about this to the Product team, here!)

    However you could potentially create your fourth sheet, then use a Report to 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!

    Cheers,

    Genevieve

Answers

  • Genevieve P.Genevieve P. admin
    Answer ✓

    Hi @PattiL

    Currently in Smartsheet dependencies and predecessors are specific to each sheet and cannot be linked across multiple sheets. (Please submit your feedback about this to the Product team, here!)

    However you could potentially create your fourth sheet, then use a Report to 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!

    Cheers,

    Genevieve

  • Thanks, Genevieve!!

    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

Sign In or Register to comment.