Auto Numbering
Good Morning,
I have multiple sheets that filter into the master sheet. The individual sheets have auto number columns, which then transfer over to the master column. We would like to number each row individually of the master column, however the auto number option is already used. Is there a formula that can be used to number each row?
Thank you!
Answers
-
On your master sheet, in the column you want to use for auto-number, place your first number.
(Let's assume you name that column [Master Number] and the first number is 1.)
In the next cell down, place this formula [Master Number]@row+1. The result should be 2. Now, drag this formula down the rest of the column, and you should see each number progress by 1 (e.g., 3, 4, 5, 6, etc.)
If your numbering system uses prefixes or suffixes, that's a more complex solution that will require some helper columns. Let me know if that's what you need.
-
Hi @Danielle Arteaga that works, however, is there a way to get the number to display only when a new row is added? When I do as listed above then it throws off the columns that follow it...
-
Not sure what you mean by "throws off the columns that follow." Adding a new column shouldn't impact the Master Order # column at all. Can you share a screen cap of what's happening?
-
As you can see it numbers and timestamps the next few columns
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!