Multiple Auto Number Columns in one sheet

If a user is able to create more than one form for a sheet, then the sheet should have the capability to generate auto numbers based on that form. The automations are built based on the forms. Currently, I have two forms and a tracking sheet. The sheet already has an auto number column in it and I wanted to ad another. That option is greyed out, so I can't assign the column type. As long as the numbering sequence is different, the feature should be enabled.

Please think about this and how it can be implemented.

Thank you!

Sign in to vote!

Find more posts tagged with

On Radar

Comments

ZjHagens

I've had the need for this in many instances. Good suggestion.

mgilkessmith

I would love to have this capability. I was actually searching how to do this when coming across this post. Additionally, it would be helpful in some instances for the autonumber column to reset if a row is removed.

Darla Brown

Yes and amen! I need this for our commissions sheet. As in I REALLY need it :)

electrichead

I was looking for how to create a second auto numbered column when I found this. I need a RequestID and then later assign it a ProjectID when the request is approved.

Pat Canning

There are many use cases for this requested functionality.

Kris V. Le

Seems like a very simple enhancement and something I would us a lot.

fcooke

As a work around can't you use a column formula to "auto number" ?

Pat Canning

https://community.smartsheet.com/discussion/comment/486256#Comment_486256

Not when transferring data between sheets, each with their own auto-number and created by different people at different times.

Quick Links

Trending ideas

Resource Management Plan Settings in Control Center - add Client and Project Code fields
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
Sheet Icon Color Consistency
The 'Sheet' icon appears purple in the left navigation but blue within the sheet, creating inconsistency. Aligning icon colors across the platform would improve clarity and simplify user training. Please standardize the icon color to enhance user experience and reduce confusion during onboarding.