Compare data from two sheets
Hello Team,
I would like to know if it is possible to use the Automation in Smartsheet to compare the data in two sheets.
Basically we use Smartsheet to manage devices and we have 2 sheets, one for Production devices and one for Lab devices.
Since we manage a large number of devices, we need to find a way to continuously compare the two sheets to see if a serial number on the Lab sheet appears on the sheet for Production, if this happens, we would like a notification to be sent out.
Basically we are looking for a duplication of serial numbers between the two sheets, but the check needs to be continuous.
Please let me know if this can be achieved in Smartsheet.
Many Thanks.
Best Answer
-
You would set up a helper column (I would use a flag type) with the following formula:
=IF(COUNTIFS({Other Sheet Unique Identifier Column}, @cell = [Unique Identifier Column]@row) > 0, 1)
Answers
-
You would set up a helper column (I would use a flag type) with the following formula:
=IF(COUNTIFS({Other Sheet Unique Identifier Column}, @cell = [Unique Identifier Column]@row) > 0, 1)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!