We use Smartsheet to manage several projects, with multiple and repeat customers. We need to create a report that reviews (2) columns (distributor and customer) from serveral sheets. We would like the end report to combine the (2) columns from all of the sheets and remove any duplicate names from each column.
I have gotten to the point where I have all of the data but can not figure out how to remove the duplicates. Can I remove the duplicates in a report? Is there an automated way to remove the duplicates in a seperate sheet?
