Generate Unique Numbers

System
System Employee
edited 10/28/21 in Formulas and Functions
This discussion was created from comments split from: Formula to count of items in a multi dropdown list.

Answers

  • Hello


    i have an excel sheet that is connected to a form I want to generate numbers From 001... How do I automatically number an item according to its kind in Microsoft excel eg. 001 will start the numbering of an item and another item will be also start from 001 eg. in (form) i have a drop down menu of different choices i want to give each choices its own sequential numbering so it means if i have camera, projector mobile phone on my dropdown list..


    it will be counting by the next entry


    camera-001

    projector -001

    camera-002

    mobilephone-001

    camera-003

    projector002

  • liz.mayeux
    liz.mayeux ✭✭✭✭✭

    If it didn't matter if the numbering was sequential you could have the autonumber column as created by smartsheet & Join formula with the column for the type of equipment.

    Camera-001

    Projector-002

    Camera-003

    =Join(Number@row +","+[Equipment type]@row+)

    if you need the numbers to be sequential according to their equipment type, then the formula gets a little trickier and you are working with if & countif formulas and embedded statements for adding the 00 in front of your number. IF this is the path you want to go by, you will want to build the formula one step at a time and add the embedded statements as each formula works properly. I would hate for you to create something long and complicated for it to error out and you don't know where it went "wrong".

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!