Return 1st, 2nd, and 3rd non-blank value per row

Options

I am trying to replicate the following excel formula in smartsheet:

My knowledge of Smartsheet is pretty limited, and everything I have tried so far has given me an error. Any help is appreciated.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!