Is there a 'Remove Duplicates' feature?
I am attempting to remove duplicate rows in a sheet but can't find an easy way to do it. I used the AI function to generate a formula for it and I got the above result. Just wondering if there is a feature to remove duplicates or if there may be in the future?
Best Answer
-
There currently is not a feature to remove duplicates. Feel free to browse the Product Ideas tab at the top of this page to see if someone has already submitted the idea. If they have, you can add your vote. If they have not, you can submit the idea yourself which will allow others to add their votes.
Either way, please post a link to the idea here so others looking for the same thing can easily add their votes.
Answers
-
There currently is not a feature to remove duplicates. Feel free to browse the Product Ideas tab at the top of this page to see if someone has already submitted the idea. If they have, you can add your vote. If they have not, you can submit the idea yourself which will allow others to add their votes.
Either way, please post a link to the idea here so others looking for the same thing can easily add their votes.
-
Created a new idea for this here: https://community.smartsheet.com/discussion/118632. Please upvote on this idea.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.6K Get Help
- 435 Global Discussions
- 152 Industry Talk
- 495 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- Good day Smartsheet Team, Getting an unparseable error on this formula: =IF($Name@row <> "",(SUMIFS({Expense}, {Period},1, {Type}, OR(@cell = "RES602782", @cell = "RES602497")),"") Trying to pull in a…
- I am working in a separate sheet for calculating metrics. I want to count the number of items in a referenced date range in another sheet that meet certain year criteria. For example, I want to find t…
- I have a column that is a contact list where a single or multiple staff members can be selected to be scheduled. I'm trying to create a formula that counts how many times each individual's names are l…