Lookup multiple columns for text value and return cell value


I'm trying to figure out a formula to return the value in a cell over multiple columns. I have 10 locations consisting of various buildings for each location. Only one column will have text in it. The formula I have will obviously only return the text for that column and I cannot figure out how to repeat the formula to check all 10 columns. Help please!

This is what is working for one column. Is there a way to repeat it for all?

=IF(ISTEXT([Main Campus Buildings]@row), [Main Campus Buildings]@row).



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!