Return a value from a different column

Hi, I'm quite new to smartsheets and trying to write a formula to look at multiple cells and return a value. In this example column 3, 4, 5, & 6 will either be empty or say approved or submitted but only in one cell. I want column 2 to look at 3,4,5.&6 and return the value that is there. If column 3 says approved then 4,5,6 will be blank. If column 4 says submitted then 3,5,6 will be blank.

thank you!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!