Return the cell with a value from 3 cells

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

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!