Report Builder

Megan Pecunia

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.

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

Bobby Andres

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.