Referencing Another Sheet Formula For Text


I added a column in a sheet that is sourced from another's for text not numbers. Which formula would I use for this one? The source correlates to the site name...I'm a little stuck. Thanks in advance!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!