TIP: Calculations on an AutoNumber Column

NeilKY
✭✭✭✭✭
I've noticed when trying to run formulas on my AutoNumber column, that it doesn't always work. Here's a table of some of the results. For each row I changed the autonumber "Numerical Places" from 0 to 00 to 000 to 0000.
You'll see that the results conclude that Formulas on an Auto Number column MUST USE SINGLE DIGIT NUMERICAL PLACES if you want to use it in a calculation.
I couldn't find this info anywhere else so hopefully this helps someone avoid a headache in the future.
-Neil
Tags:
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.4K Get Help
- 430 Global Discussions
- 152 Industry Talk
- 492 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 76 Community Job Board
- 504 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives