I have 2 SmartSheets. The first one (Sheet1) has customer data with some transactional information ('Customer Number', 'Order Number', 'Order Number', 'Licenses Used', etc.). The second one (Sheet2) has all transactional information ('Customer Number', 'Part Number', "Serial Number', 'Entitlement Complete (Y/N)', etc.).…