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
-
An actual system generated auto-number column won't work for this, but it can be done using a formula. Are you able to provide a screenshot with sensitive/confidential data removed, blocked, or replaced with "dummy data"?
-
Sure, see attached.
I thought about using formulas, but can't get my head over how to make it work
-
How would you want your "auto-number" to look?
-
QUAxxx where the xxx will be sequential.
A new number is issued everytime that we have a new despatch date for an individual lab. If we despatch on the same day for 2 labs, i need 2 numbers
-
Will it always be "QUA"?
-
@Paul Newcome Yes, it has to be. Department specific
-
Ok. I may have a few more questions to figure out exactly how this numbering will need to work, but hopefully this gives me what I need...
Lab..........Date..........#
A..............3 Feb...........?
A..............3 Feb...........?
B..............3 Feb...........?
B..............3 Feb...........?
A..............4 Feb...........?
A..............4 Feb...........?
B..............3 Feb...........?
C..............3 Feb...........?
Based on the above... What exactly would be your auto-numbers and why? Does the number need to include a date stamp or a lab reference?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!