Multiple predecessors for a task


Hi Community,

I would like to to set both Task A and Task B as predecessors of Task C. A and B end date would determine the start date of Task C through Finish to Start dependencies.

However, Task A and B can run in parallel (no dependencies to be set between A and B) but may have different end dates, thus, Task C should only start after the latest end date of A or B. Moreover, Task B may not be always necessary, therefore, in some cases Task B start and end date may be blank. Is there a way to automate this?

Many thanks!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!