Calculating a Duplicate if meeting 2 separate criteria
Hi, I'm currently calculating if something is a duplicate by using the following formula:
=IF(AND([PASS NUMBER]@row <> "", COUNTIFS([PASS NUMBER]:[PASS NUMBER], [PASS NUMBER]@row) > 1), "Duplicate", "Not a Duplicate")
However, I now intend to expand the use of this sheet, so would like to include another column to specify the site. How can I incorporate the site column to determine if the row is an actual duplicate?
e.g. if two '14' pass numbers were issued. One for the Hay site and one for the Cardiff site. I wouldn't want this to flag as a duplicate. Only if '14' was used twice at the Hay site.
Thanks!
Best Answer
-
If I understand your request, this should work for you.
=IF(COUNTIFS([Pass Number]:[Pass Number],[Pass Number]@row,Site:Site,Site@row)>1,"Duplicate","Not Duplicate")
Answers
-
If I understand your request, this should work for you.
=IF(COUNTIFS([Pass Number]:[Pass Number],[Pass Number]@row,Site:Site,Site@row)>1,"Duplicate","Not Duplicate")
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!