Good afternoon,

I am trying to create a formula that searches 2 cells with a row, and if both are blank then it will return "Online", but if either one has a value in it then it will return that value. The two cells will never both have a value in at the same time, just one or the other.

The cells are as follows:

Unscheduled Downtime Reason

Scheduled Downtime Reason

If both are blank then it should return the word "Online", if either have a value then it will return the value.

Thank you for your help in advance!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!