Best Practice
Best Practice
Review best practices, tips and tricks, and more from fellow Community members.
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.7K Get Help
- 437 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Other Best Practices
- Here is the full solution for how to iterate over an array using JavaScript. Smartsheet provides a partial and incorrect solution at . Below is the actual solution. Using Bridge and JavaScript, this e…
- 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…
- Issue: Have you ever filled out a form and noticed that the submissions aren't showing up in the sheet where they should? This is a common problem, but there's a simple solution! Cause: This usually h…
