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.


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. 







  • 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!



    Community Help.JPG

  • 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.



This discussion has been closed.