How to pull info into a cell

Hi! I would like to search the columns in a row and return whatever value is found on the row. Then I need to add the word "Project" in front of whatever value is found. What is the formula I would use for that? Here's a snippy of a sample of what I'm working on. What formula would go in the yellow column to return the values in the IL, PA, TX and NM rows?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!