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, smartsheetguru.com
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)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!