nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Welcome!

Either/Or Dependencies?

TRach

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?

Find more posts tagged with

Sheets

Enhancement Request

Comments

L_123

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

TRach

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

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

TRach

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

L_123

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

Sign in to join the conversation!

Quick Links

Trending discussions

Requests in Table View
Does anyone know how to add multiple rows to a request? I am only seeing an option to send one row at a time. In grid, you can select multiple rows and do one row update for them all, but I can't find this option in table view. Thanks! Regina
Colours have changed from default Smartsheet colours to new ones - how do I get default colours back?
Hi there, I'm not sure if I'm losing my mind, but when I logged back into my sheet today I have lost the default colour settings for sub-milestones and status (see screenshot) How do I revert back to the default colours for these? Is there a way to do this? Many thanks.
2 line chart widget
Please help! I've tried Smartassist with no luck! I'm creating a project financial tracking template and have hit a challenge with charting. My source sheet contains one row per month and includes: Financial Month (stored as text) Actuals (Cumulative) Forecast (Cumulative) A helper column called "In Plan" that I use for…