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.
Answers
-
Please also take into consideration the Parent rows are what we are trying to find the duplicates of.
Sorry I forgot to include this.
-
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.
-
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)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!