How to Remove Duplicate Site Names??

John- Michael Diedrich

Hey Smartsheet Community,

I am trying to remove duplicated Site Names from my sheet and am running into some issues. Can someone please help me come up with a formula to accurately remove all duplicated site names? (Backstory: I copied a lot of data over and some of it is duplicated so we are trying to remove the duplicates).

Below is a screenshot of the site name column and the duplicate column I have next to it.

Please let me know if you have any questions, I am hoping this is easier than I am thinking.

John- Michael Diedrich

Please also take into consideration the Parent rows are what we are trying to find the duplicates of.

Sorry I forgot to include this.

John- Michael Diedrich

Here is my current formula:

=IF(COUNTIF([Site Name]:[Site Name], [Site Name]@row) > 1, 1, 0)

I just need to figure out a way to only check the parent rows. We can tell if it is a parent row because we have a Level column and all parent rows are level 2 in it.

Summer

@John- Michael Diedrich

You could try updating your formula to be a COUNTIFS and then adding in the parameter to check if the level column is 2.

On my test sheet here is what that looks like:

=IF(COUNTIFS(Level:Level, 2, [Site Name]:[Site Name], [Site Name]@row) > 1, 1, 0)