Remove duplicate formula has changed and now need to be corrected.
This is the formula to remove a duplicate that is already on a report:
The number circled in read was not part of the original formula and I don't know why it is there. I have found a duplicate on the report where before all duplicated were being removed. Does anyone know why this has happened and how to correct this?
Answers
-
@Mark Stacey Did you check the cell history and see if anyone edited that cell?
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
Checked the cell history and nothing was edited.
-
Most likely the sheet was sorted.
To avoid this, you can use an auto-number column (with no special formatting) and convert it into a column formula.
=IF(COUNTIFS([Auto-Number]:[Auto-Number], @cell<= [Auto-Number]@row, [NJUNS Tcket#]:[NJUNS Ticket#], @cell = [NJUNS Ticket#]@row)> 1, 1)
-
Thanks Paul! What is meant by 'sorted'? and why would that happen?
-
If someone sorted the sheet, it could move what was originally the top row to further down in the sheet. Since you were referencing that specific cell, the cell reference would have been updated.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!