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.

Cross referencing two Sheets

Options
Andrew Henderson
Andrew Henderson ✭✭✭
edited 12/09/19 in Archived 2017 Posts

Hi All

I am currently using a web form to collect data for a staff onboard systems which is working great, however, I need a way to cross-reference the data coming in from the form to a list of people I am expecting.  until the vlookup feature arrive later this year any ideas on how to do this would be greatly appreciated

Regards 

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Options

    Sure, I've seen several people do this.

    1) Make sure your form entries appear at the top of your sheet. 

    2) Add the list of people to the bottom of your sheet. 

    3) Use Lookup to search the list of people in the bottom of your sheet. https://help.smartsheet.com/function/lookup



    Hope that helps. 

     

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    Options

    I do this using the JOIN() function and a column to check for inclusion.

    As new forms come in, the check will determine if they are NOT in your expected list (likely a typo?) and on the expected list sheet, it would show when they have submitted a form.

    Two Reports are used to show they two results.

    I've procrastinated on writing it up as cross sheet lookup has been 'coming' for a while.

    Craig

This discussion has been closed.