Autonumber
I am looking at the auto-number system, is there any way to have the id match another two columns?
Answers
-
Hi @David Rice ,
Setting column property to Auto-number gives you a couple options to customize the number generated. Picture below.
If you want to use data from another column(s) you can place a column formula into your ID Number column. To get auto-numbering you can combine this with an auto-number column. Your ID Number column formula would be something along the lines of =[column5]@row & "-" & [column12]@row & "-" & [auto-number]@row. If you go this route realize that if the data in the other columns is changed, the ID Number will change.
Any help?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.4K Get Help
- 447 Global Discussions
- 144 Industry Talk
- 479 Announcements
- 5.1K Ideas & Feature Requests
- 85 Brandfolder
- 151 Just for fun
- 72 Community Job Board
- 490 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 302 Events
- 36 Webinars
- 7.3K Forum Archives