How to Remove Duplicate Site Names??

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.

Find more posts tagged with

Formulas

Accepted answers

All comments

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)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.