Auto number

I have a spreadsheet where i keep track of all the samples that we've sent for laboratory testing. They all have a despatch date and the lab that they are being sent to. Is it possible to set up the Auto-number system to generate only one number for all the rows with the same lab and date?

The goal for this is to create reports to the accounts department, while automatically generating on my side the "Purchase Orders" for the lab tests.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!