Auto Number/System
If I want to set the Auto Number (Ref. No.) to start from the specific row, How can this happen?
For example, If I want to start the no. from row 208
Answers
-
@Hana Attia - I would recommend avoiding the auto-Number/System column property. You can solve this with formulas, but the complexity of the formulas depends on A) whether you need to dynamically move rows up and down, and then B) whether you want those unique row IDs to remaining static after they are applied.
Here's a good start to setting up helper columns behind the scenes: https://community.smartsheet.com/discussion/6757/formula-to-determine-row-number
Here's a quick start to a formula to begin populating at row X:
Alternatively, you could consider an automation that pastes the value of a hidden cell into your next row. The hidden cell would be a formula to calculate the next largest value in your series.
I hope that is helpful to you
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.4K Get Help
- 432 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