Flagging a duplicate reference across 2 sheets
I have an intake sheet for users to submit a New Supplier Request. This generates a New Supplier Document. Once created, this entry moves to an archive sheet
There will be scenarios where someone will submit a request for a New Supplier, of which a document already exists: I want to eliminate this issue as I cant have two documents for the same Supplier
I would need a 'Duplicate' checkbox on intake which contains a formula to 'LOOKUP' the 'Supplier Name' field and return a 'yes/checked' to stop the automation taking place.
Any ideas of what that formula would be?
Best Answer
-
For the duplicate column, you can set that to a checkbox field then use the following formula
=IFERROR(IF(MATCH([Supplier Name]@row, [Supplier Name]:[Supplier Name], 0), 1, 0), 0)
or
=IF(COUNTIF([Supplier Name]:[Supplier Name], [Supplier Name]@row) > 1, 1, 0)
...
Answers
-
For the duplicate column, you can set that to a checkbox field then use the following formula
=IFERROR(IF(MATCH([Supplier Name]@row, [Supplier Name]:[Supplier Name], 0), 1, 0), 0)
or
=IF(COUNTIF([Supplier Name]:[Supplier Name], [Supplier Name]@row) > 1, 1, 0)
...
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!