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.

Report Builder

Megan Pecunia
edited 12/09/19 in Archived 2016 Posts

I would like to build a report from two sheets that uses the same number to identify items and fills the columns in that correspondes witht that number.

For example- Take the UPC of one item and grab the revision date from one smartsheet and the backstock quantity from another smartsheet.

I looked through help articles and forum questions, but haven't found the answer.

Tags:

Comments

  • Brett Evans
    Brett Evans ✭✭✭✭✭✭

    Megan,

     

    This is not currently available in Smartsheet, but is on the roadmap, hopefully soon.  You are loking fo a VLOOKUP function.

     

     

    As a work around you can build a report that sorts by UPC number.  Then the Data would be on concurrent rows.

    -Brett

  • You can use cell linking to bring in information on a product from multiple sheets. This would need to be set up manually for each item but it would get the results you are looking for. 

This discussion has been closed.