Different options for autonumbering

FTesseneer · 04/08/25

I have an Die log that has different tabs for different types of dies. Each type of die has a different numbering system. I would like to create a Smartsheet with form so that when someone chooses a type of die that it autonumbers for that type of die. I found this on Copilot, but I am still confused by it. Can someone help me design my Smartsheet? I have named my "Choice Column" "Type of Die". Thank you in advance!

Freda

Step 1: Create Your Smartsheet Columns

Choice Column: This column will capture the user's choice from the form. Let's name it "Choice".
Helper Column for Autonumber: This column will generate the autonumber based on the choice. Let's name it "Helper Autonumber".
Final Autonumber Column: This column will concatenate the choice and the autonumber to create a unique identifier. Let's name it "Unique ID".

Step 2: Set Up the Helper Column Formula

=IF([Choice]@row = "Option 1", COUNTIF([Choice]:[Choice], "Option 1"), COUNTIF([Choice]:[Choice], "Option 2"))This formula checks the value in the "Choice" column. If it is "Option 1", it counts the number of "Option 1" entries up to the current row. If it is "Option 2", it counts the number of "Option 2" entries up to the current row.

Step 3: Concatenate the Choice and Autonumber

=[Choice]@row + "-" + [Helper Autonumber]@rowThis formula combines the choice and the autonumber to create a unique identifier.

Example

Here's how your Smartsheet might look:

Choice	Helper Autonumber	Unique ID
Option 1	1	Option 1-1
Option 2	1	Option 2-1
Option 1	2	Option 1-2
Option 2	2	Option 2-2

Step 4: Test Your Form

Create a form in Smartsheet that allows users to select from the choices (e.g., "Option 1" or "Option 2").
Submit a few entries through the form to ensure that the autonumbering works as expected.

By following these steps, you should be able to have different autonumber sequences for different choices in your Smartsheet form. If you run into any issues or need further assistance, feel free to ask!

FTesseneer · 04/08/25

Ok, I am answering my own question. This will not work for what I am doing. The helper autonumber column is counting the number of each choice and using that for the autonumber. There is a specific numbering system for each type of die. So I don't believe that I can make this work.

If anyone does see a way that I could make it work, please let me know.

Thanks!