Skip to main content
Hello All,

 

I am tracking unique serial numbers (text field) in an inventory object and every serialized item has a status (Receiving, Testing...Stocked...Shipped (out of system).

 

I want to prevent the duplication of serial numbers IF the previous duplicates are NOT "Shipped".  In other words, you can never have a duplicate SN in the system at the same time unless the other duplicate(s) are in the "Shipped" status.  I can't use the "Unique" setting on the field, as this is too stringent and can't figure out the sequence with VLOOKUP + the additional layer to get my validation to work.

 

Any help would be greatly appreciated.

 

Thanks!

 

Marino
5 réponses