Either/Or Dependencies?

TRach · 12/06/19

I want to be able to use a dependency like "either/or" instead of "and"

ie: Task 3 can start after either Task 1 or Task 2 is finished, but does not require both tasks to be done.

Is this possible?

L_123 · 12/06/19

=if(or([Task 1]@row = "Finished",[Task 2] = "Finished"),1,0)

TRach · 12/06/19

Thanks for the reply, but this seems to be saying "if task 1 is complete, task 2 is also complete" but that wouldnt be the case.

Task 1 and 2 wont be completed at the same time. But one of them needs to be done before Task 3.

L_123 · 12/06/19

I misunderstood, you mean how to set the predecessors on a project sheet then right?

TRach · 12/06/19

Yes. I can make it use both predecessors, but I want it to use one *or* the other.

L_123 · 12/06/19

Someone may correct me if I am wrong, but I am fairly confident you are unable to do that currently in smartsheet. There is not mention of it in the official documentation. I recommend submitting a product enhancement request via the link on the right side of the community webpage.

https://help.smartsheet.com/articles/765727-enabling-dependencies-using-predecessors

Either/Or Dependencies?

Comments

Categories