Unique documentnumbers


I would like to know if is possible to create unique documentnumbers based on input in coloumns. Or more important the opposite, prevent that a number is used twice.

E.g.: Metadata

Projectnumber will always be the same, drawingtype 1 will/might be different, drawingtype 2 will/might be different, area code will/might be different and so on. Within the different combinations of metadata I want to make sure that the serial number is not equal to serial numbers used before.

E.g.: Many 3D drawings will be generated through the project, many HP drawings will be generated through the project with same area code, same system, same originator. The only way to separate them from each other is the serial number.

Is it possible to generate unique numbers taking the above into account?

Best regards

Anne NO


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!