Formula for duplicate data?
Quick question! Is there a formula or something that can alert me if there's any information in two different cells that are duplicated?
For example…we code our clinic sites with three letters (ABC or DEF) in one column. Is there a formula that can let me know if it's ever duplicated? Thanks!
Answers
-
You could use a conditional formatting to identify duplicates. You can also create a helper box column to check if certain cell matched other cells within the row and use that as a trigger to alert you.
Leroy Noriega | Smartsheet SME | Independent Smartsheet Consultant
Core App, Project Management and System Administrator Certified🏅
E: leroy.noriega@yahoo.com | Linkedin Profile
-
@Leroy Noriega I did the conditional formatting, but it only highlights the cell and we have up to 200 rows so it would be difficult to notice unless I get an alert. Do you have some tips on what to put to trigger me if certain cells matched other cells? That's where I'm stuck 😕
-
The conditional formatting can be changed to highight the whole row.
I recommend creating a helper Checkbox column to the right side of your sheet. In here create a the IF formula to do the cell comparison, if duplicates then 1, if no duplicates then 0.Convert the cell into a column formula.
Create an automation to email you/alert you when the box is checked.
Leroy Noriega | Smartsheet SME | Independent Smartsheet Consultant
Core App, Project Management and System Administrator Certified🏅
E: leroy.noriega@yahoo.com | Linkedin Profile
-
Got it thank you!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives