I am trying to identify duplicates on a sheet using a check box
I want to identify duplicates on a sheet using a check box but I want to ensure that 2 conditions are meet. If the amount is the same and the Internal Wire ID is the same.
I am using this formula to look for matches in amount, =IF(COUNTIF(Amount:Amount, Amount@row) > 1, 1) but I am getting too many positive so I want to have it look at the Internal Wire ID (this is another column) and see if it is a duplicate as well.
I have also tried setting up two columns using, =IF(COUNTIF(Internal Wire ID:Internal Wire ID, Internal Wire ID@row)> 1,1) but this is showing #UnPAR I am assuming because it is not a numerical amount.
Thanks for your help
Best Answer
-
you should be able to use =IF(COUNTIFS(Amount:Amount, Amount@row, [Internal Wire ID]:[Internal Wire ID], [Internal Wire ID]@row) > 1, 1)
When a column name has more than one word it needs to be in brackets [column name]
Answers
-
you should be able to use =IF(COUNTIFS(Amount:Amount, Amount@row, [Internal Wire ID]:[Internal Wire ID], [Internal Wire ID]@row) > 1, 1)
When a column name has more than one word it needs to be in brackets [column name]
-
Thank you! Working great.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives