Is there a way to identify if a column has duplicate numbers
Hi
I have a Smartsheet that has a column for File # which are unique and shouldn't be any duplicates, is there a way to identify if a column has duplicate numbers and set a conditional format or some indicator?
Thank you
Best Answer
-
Hi Roshni,
I'd try this.....
Create a helper column that is a checkbox. Then add this formula:
=IF(COUNTIF([File #]:[File #], [File #]@row) > 1, 1)
or check out https://community.smartsheet.com/discussion/72866/formula-to-remove-duplicates-in-a-column. The answer uses a helper column and a date create (system) helper column.
Hope this helps.
Don Wilcox
drwilcox.57@gmail.com
Answers
-
Hi Roshni,
I'd try this.....
Create a helper column that is a checkbox. Then add this formula:
=IF(COUNTIF([File #]:[File #], [File #]@row) > 1, 1)
or check out https://community.smartsheet.com/discussion/72866/formula-to-remove-duplicates-in-a-column. The answer uses a helper column and a date create (system) helper column.
Hope this helps.
Don Wilcox
drwilcox.57@gmail.com
-
Hi Don
Thanks vey much this worked great and then I ran a report to filter out what is not needed.
Appreciate this community, always so helpful.
Cheers
Roshni
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives