Auto number
I created a sheet to track problems that arise on my project. I also created a form that my team can use to enter in those problems. On my sheet you can use the form or manually enter in the issue but for some reason the Auto number feature in my Issue ID column isn't calculating the issues entered correctly. The numbers are at random and have no particular order. Is there a way to fix this? I provided a picture for more context. Here I have three listed twice.
Answers
-
Hi @bburns
I hope you're well and safe!
Strange!
Did you have anything filled in before you activated the Auto Numbering feature?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I would say no, I did test the form but I deleted what was entered and started over.
-
It could be that the users filled in a row that wasn't next or that they moved them around. The issue with multiple of the same is strange, and the only thing I can think of is that a form and a record in the sheet happened simultaneously.
Make sense?
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
That makes sense but in that example the #3's were entered on different days.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives