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.
I have an inventory I do each month and have a fairly simple question but not sure what is the best way to complete this task. I have 3 columns. ItemNumber, ItemName, and TotalQTY. The first sheet is what I actually have on hand in the warehouse the second sheet is what our system says we should have. So far very simple. The problem is the system has items that we do not have in our warehouse and some items that are in the warehouse are not in the system. I want to merge the two sheets so it will have all of the data on one sheet while showing the TotalQTY of each so I can see the variance between the two. I understand that some rows will not have a variance since they will not be in both sheets.