Multiple dependencies - can I use a range?

Hi all,

I'm trying to build a template project plan and I want to set my milestone date to be dependent on when all the other children from that parent are completed. But I also want to be able to add rows (siblings) under that parent. Is there a way to set a range of predecessors or do I need to keep manually updating the predecessors for the milestone every time I add a row to that section of the project plan?

Jeanne

Best Answer

  • Jeanne Wilson
    Answer ✓

    I figured it out. Instead if having all my tasks as siblings at the same level as my milestone, I added a milestone-level task called "Phase Tasks", and indented all the subtasks I wanted the milestone to depend upon under this "Phase Tasks." THe milestone becomes the sibling of "Phase Tasks" and takes it dependency from "Phase Tasks." Basically I made all the tasks I wanted my milestone to depend upon into their own grandchild group.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!