I've created two sheets to track different elements of product development. Each sheet has data associated with a product (product name, product key). Now I want to use the Smartsheet for Google Docs merge tool to generate a product report.
My trouble is in rolling up the product data from the two sheets into one. The combined result needs to have a single row for the combined data.
I've tried the reports - but it doesn't combine into a single row.
I've tried creating a new sheet with linked cells but gave up as it was such a headache... too many rows and columns!
Next I'll try a vlookup, but expect this will not be very easy and prone to error.
Any ideas?
