Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Problems with LOOKUP formula
I'm encountering an issue with the LOOKUP formula in Smartsheet.
Apparently it doesn't work with the names that I use in my lookup range (note that I dragged the formula down to the bottom, using "$" to block the rows of the range, but I get no results):
I would like to understand why it is not working and if there is a simple way to solve this.