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