Automatic calculation of lag time

Anna Tezcanli

Hello Smartsheet community!!

I hope someone can help me with the following question:

 

I have 1 activity that depends on another BUT does not necesarly needs to start right after the predecent activity finish. I know that the duration of the activity is 2 days, and the exact date when it has to be finish. Is there any way to set dependency and the end time so Smartsheet automatically calculate the lag "days" ?

 

Hmm difficult to explain so tons of thanks for any help.

 

KR,

Anna

 

 

J. Craig Williams

Anna,

 

If I understand correctly, you have two conflicting constraints.

1. Task C can start after Task A is completed.

2. Task C must finish before a deadline (let's call that Task

 

You first option is to see Task C's predecessor to Task B as a Finish-to-Finish relationship.

This means that Task C can't finish before Task B finishes.

With a 2 day duration, this will show up with a [Start Date] of 2 days before the deadline.

 

Then set a Conditional Notification on Task A to send an email to the person responsible for Task C when Task A is finished - letting them know they can start.

 

Craig

 

Anna Tezcanli

Hello Craig and thanks a lot for your comment.

I think I will rephrase my question so it's easier to understand.

My question is only about 2 tasks, I liked the way you formulated your answer so lets keep calling them A and B.

 

Example:

 

1. Task A finishes the 31st of Jan and tasks B depends on tasks A but I want it to start on May 25th.

2. I know that tasks B only takes 2 days to perform.

 

The only way for me to ensure that the Gantt Chart is correct with dependencies between A and B is adding the correct lag days between the 31st of January and May (this I have to count manually).

Smartsheet only allows me to write the exact number of days between this 2 dates. Is there any way for me to only choose the exact date when I would like task B to start? or do you have any other way to do this?

 

I hope my questions i more clear now 

 

Kind Regards,

Anna

 

 

 

 

J. Craig Williams

Anna,

 

In my opinion, you have TWO constraints on Task B.

1. Task A completed.

2. Start no earlier than May 25th.

 

In some other PM tools, you can set both of those in the constraints for Task B.

Not in Smartsheet.

The way I get around this is to add another task (C) with 0 duration and start/end dates of May 25th.

Task B then points to Task A and Task C.

If Task A goes past May 25th and the schedule is updated to reflect it, Task B's start date shifts.

 

(Note that Task A/B/C no longer match my other post)

 

Craig

Anna Tezcanli

Interesting workaround. I will try it for sure!

Thanks a lot Craig for your good advise always really appreciated.

 

Have a lovely day,

Anna