Compare data from two sheets

Emskie321

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.

Paul Newcome

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)