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.

LOOKUP

Options
Stephanie Taylor
Stephanie Taylor ✭✭✭✭✭✭
edited 07/20/17 in Archived 2017 Posts

Can someone please help?  I cannot figure out why this formula is not working.

Fyi..the Current Designation column is column number 2. 

 

 

LOOKUP.JPG

LOOKUP.JPG

Tags:
· Share on FacebookShare on Twitter

Comments

  • SmSulli
    SmSulli ✭✭

    Stephanie,

    I think a couple tips will help you out.  Your selection for the look up table should include both the look up data column and the column with the return values you want in the Results.  Also the look up data column must be the left most column of your selected columns.

    Good Luck!

    Shawn

     

    Community Help.JPG

    · Share on FacebookShare on Twitter
  • Stephanie Taylor
    Stephanie Taylor ✭✭✭✭✭✭
    edited 07/20/17

    Unless I am misunderstanding you that is how I have the formula set up.

    Never mind, I got it.

    Thanks!

     

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories