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.

Consolidating names in a Columns

edited 12/09/19 in Archived 2015 Posts

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?


  • System
    System Employee Admin
    edited 10/15/15

    Hello Phil, 


    Currently there isn't a way to remove duplicates from a report or a sheet, but I'll add your vote for this capability to our enhancement request list. 


    We appreciate your input! 



This discussion has been closed.