2 or more projects sheet dependency

Dynamics
Dynamics
edited 12/09/19 in Smartsheet Basics

HI,

I am using Smartsheet and I am involve in 3 projects and all are main and lead roles.  I made 3 separate sheets for each project but I realize each projects affect the other projects and then sometimes the predecessor is in another sheet.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

For example:

Project A sheet

Task # 25 on Project A

Project B sheet

Task #100 on Project B sheet depend on some task on Project A  task #25 sheet is the predecessor 

Project C sheet

Task #88 on Project C sheets depend on some Task #100 on Project B sheet as the predecessor  

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Is there a notation, process or technique that handles multi sheet.

I was expecting that it has the power like excel to refer to a cell with another sheet.

=SUM([Budget.xlsx]Annual!C10:C25)

In the above notation I get the data from another workbook.  I hope you have a function that can do external reference.

Temporarily I made a work around by just putting the 3 projects in 1 sheet which is very long.

If the function that I am suggestion does not exist,  I hope you put it on next release and give me a buzz and I will also willing to test the suggested functionality.

 

Thanks,

D Micu

 

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi Danilo,

    You could use cell linking or maybe you could have everything in one sheet and use filters instead.

    https://help.smartsheet.com/articles/861579-cell-linking

    https://help.smartsheet.com/articles/504659-using-filters-to-show-or-hide-sheet-data

    Would that work for you?

    I hope this helps you!

    Best,

    Andrée Starå - Workflow Consultant @ Get Done

    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.

  • Dynamics
    Dynamics
    edited 07/25/18

    Thanks for the tip and tried it and I have 3 separate sheets for each project and the dependency link perfectly.

    But I discover something that is a problem

    For example I change the duration on a task project A that project B is dependent on I am expecting that project B will adjust.

    I thought the reason that Project B did not update is because it was not refreshed.  I did the refresh of the web page but it did not update. 

    It is not efficient to go to the project B sheet to correct the start date by relinking again.   What if I change a lot of task that project B or Project C is dependent on and they are cascading dependencies

    In excel changing a value on one workbook will also update the other workbook is dependent on. 

    Is there any easy work around to this or made a mistake or I am missing something or I am working on too many projects at the same time (LOL)?

    Thanks,

    D Micu

  • Dynamics
    Dynamics
    edited 07/25/18

    Hi,

     

    At last I know the reason why Project B did not update:

    1) I need to save Project A after altering the duration.

    2) On project B there is a Blue indicator that the link value was altered on another sheet.

     

    I will try doing 3 projects with cascading dependency.  Let us see this will work.

    Mystery: How many cascading dependency can smartsheet can do without any problem?

    Thanks for the help,

    D Micu

  • Mattias
    Mattias ✭✭

    Did you get the dependency thing to work with this setup?

    I am playing around with a possible setup to have two sheets with different information but a dependency need between them.

    Example

    Sheet 1 - Task 1 needs to be done before Sheet 2 - Task 1 can start.

    Was playing around with cell linking but couldnt find a way for the predecessor to work like above...

    I am aware of the possibility to put everything in one sheet and work it out there, but the reason for playing with different sheets was to see if there is a way to make things a bit less daunting for people jumping into Smartsheet. The current master sheet is growing to a monster when I have 300+ meeting rooms that needs furniture from one supplier and AV from another...

    If I could make two separate sheets of this then I could share each sheet with a separate supplier and they can only see what they need to keep track of.

     

  • Hi guys,

    Did anyone manage to get this to work?

  • Sandra Guzman
    Sandra Guzman ✭✭✭✭✭✭

    I am here searching for the same - an answer to be able to track dependencies across project sheets without having to link cells across sheets.

    I already submitted a Product Enhancement Request (available under additional resources in blue font - menu found to the right).

    We have more than 400 projects currently operational with different folks managing various tasks within each project and I need an easy way for us to track this so any tips or suggestions would be greatly appreciated.

    Thanks!

  • GoGators
    GoGators ✭✭✭

    For each task in project B that had a dependency on a task in Project A, I created an extra milestone task in project B (i.e. w/ zero duration), e.g. called "Dependency from Project A". For this new milestone task, I kept the predecessor field blank and linked the start data cell to finish date of the task it is dependent on in Project A. This seems to do the trick for me. Changes to project A seem to auto update in Project B.

  • Lori Hight
    Lori Hight ✭✭✭✭

    Yes linking the Project start date to the previous plans start date is good but you also should link the duration so that it is completely dynamic.

  • Also waiting on a solution for this. From my Google search, this has been a topic on Smartsheet forums since at least 2016, but no such feature has been implemented by Smartsheet as of yet...