Can I identify duplicate values by rows not just by column?
I need to ensure that entries to this sheet are not duplicated based on three columns, the name, the activity, and the start date. The examples I've found only review duplicate values within a column.
thank you for your help!
Answers
-
You could easily combine the 3 columns in a backend column and then look for duplicates in that new column.
Hope this helps!
-
I typically create a helper column and do a COUNTIFS formula. Anything over a 1 would be a duplicate. You can then set up any conditions you need to do what you want to with the duplicate row.
=COUNTIFS([Employee Name]:[Employee Name],[Employee Name]@row,[Activity]:[Activity],[Activity]@row,[Start Date]:[Start Date],[Start Date]@row)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 516 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!