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!
