Multiple dependencies

Daniel Kumar
Daniel Kumar ✭✭✭
edited 10/06/21 in Formulas and Functions


I have an issue that I'm not able to solve:

In this example I tried to define the beginning and the end of task 3 to be dependent on task 1 and task 2, respectively.

I want Task 3 to start when task 1 starts, and for the end of the event “finish-finish” with task 2.

As you can see, it automatically sets the correct end date. But the duration is set to 1d and does not start at the correct start date.

I want it to look like this:

So if task 1 or 2 have any changes, this will affect the duration of task 3).



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!