Customize an auto number
I would like to know how to customize an auto number for a Smartsheet that I currently have. I would like to incorporate the Date, Business Unit, and the type of request. For example, (CAL-BU-QC-01022025). I have column created for each data input.
Answers
-
hi @Sam.S,
The best would be creat extra column (helper) that would be a formula column an the formula shall be sth like: =BusinessUnit@row+"-"+TypeofRequest@row+"-"+Date@row+"-"+AutoNumber@row etc. so this one columnw when you summ it all will be unique because of the AutuNumber column.
Hope it helps
The Real Smartsheet Enthusiast
Is there anything else we can help you with? - book your time!
MASA Consult - Your Aligned Smartsheet Partner
Find us on LinkedIn!
-
Input Formula
=RIGHT([Submission Date]@row, 8) + "-" + [Business Unit]@row + "-" + [Test Request]@row + "-" + COUNTIFS([Auto Number]:[Auto Number], @cell <= [Auto Number]@row)
Output
01/31/25-Shields-TSE-1
Desire Output
CAL-Shields-TSE-013125
FYI
I added CAL to the prefix of the Auto Number
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!