Referencing Another Sheet


I am entering data (BC23-111) in red block, and trying to reference another sheet to pull back the file name when there is a match of BC23-111. I keep getting a #UNPARSEABLE error message. I feel like I am close but cannot seem to get past this error. Any/all assistance is appreciated, thanks.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!