Return the cell with a value from 3 cells

Lee Wood

Good morning all,

I can't get my head around this one so wanted to see if anybody can help.

I have 3 columns:

Downtime Start Time

OOO Start Time

Manual Downtime Start Time

I would like a formula in a different column that searches all 3 of these cells and returns the first one that isn't blank. Is this possible?

Thank you in advance.

Lee

Andrée Starå

Hi @Lee Wood

I hope you're well and safe!

If the columns are beside each other.

Try something like this.

=JOIN([Downtime Start Time]@row:[Manual Downtime Start Time]@row)

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!