Multiple predecessors

Krzysztof,

I don't think so.

Task A FS and Task C SF can be any variable length duration between A's end date and C's start date and still satisfy the finish-to-start and start-to-finsih relationship.

Smartsheet does not handle constraints in quite the same way as some other PM tools do.

If the dates for A and C are truly fixed (no predecessors), the B is fixed too, isn't it?

Craig

Krzysztof,

The durations can be calculated, but not added to the Duration column as we are not yet allowed to add our own formulas there. Probably never will be.

I assume the problem is not the initial planning, as you of course just change the duration from 1d to 8d manually during that stage.

Note that you can change the Duration but not the start or end dates - changing those removes your Predecessors

Off the top of my head, here's a few aids to add:

1. Add a column to trigger a Notification on completion of Task A - and have that Notification go t othe owner of Task B and the PM.

- this will let the person know they can begin even though the date on the schedule is still in the future

2. Add a column to calculate date differences and trigger off them

since Task B is on line 7, something like this

=IF(OR(ABS(Start7 - Start6 - 1) > 0, ABS(Finish7 - Finish8 + 1) > 0), "check", "")

will show "check" if the dates do not line up (the +/- in the formula accounts for the date offsets due to dependencies). Other results may make more sense to you.

- this will allow a trigger if the dates for Task A or C move and result in a different gap between them - meaning you'll need to update the Duration column again.

I can think of a few more, but those should get you started.

I hope this helps.

Craig