I have just started using the SmartSuite and was having issues with duplicate records in the primary key. This was occurring because currently the import tool does not check for a unique constraint before importing. I wish it did and that it was identified in the errors when importing.
For now I've tried to find an easy way to identify duplicate rows. The suggestion given by help was to group the row and then I will be able to see groups of the column greater than 1. It worked in general, but I had to scroll to see if there was a group more than one because this approach doesn't allow you to court the counts of the group or anything like that.
I've found a satisfactory solution by using charts. I create a bar chart I put field I want to check in the values and count the values. I can then sort the values. I've found this will make it very easy to see the duplicates. Then I can work on fixing them.
Here's my chart and you can see it's very easy to see my duplicates:
I can also click on the bar I want to work on and easily delete, or export the rows to determine what I want to do with them whether it's to merge, delete, or modify something related to them:
