Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Multiple dependencies

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

Hi,

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.

Skjermbilde 2021-10-06 kl. 14.33.10.png

I want it to look like this:

Skjermbilde 2021-10-06 kl. 14.36.09.png

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


Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions