Formula to return any text found in range of cells?


I'm looking for a formula to return the exact text in a range of cells. Each row will only have one cell that will have text in it. I don't want to know True/False if there is text, but rather what the exact text is. The fields are drop-downs connected to a form.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!