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"?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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"?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@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?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 371 Global Discussions
- 203 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 448 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!